将数据导出到顺序文件 [英] Export data to sequential file

问题描述

不确定这是否是发布此查询的正确位置，所以请提前道歉。


我有两列在访问表中。


2条记录示例：


字段1 - 零售

字段2 - 周六

字段1 - 直接

字段2 - 太阳


有人能告诉我如何将其输出为顺序文件吗？所以文本文件是Retail＃Sat？Direct＃Sun？ ...以便在字段1之后插入哈希并在字段2之后输入回车。


任何帮助都将受到赞赏。

解决方案

它必须是哈希吗？你可以用csv做同样的事情。

它必须是哈希吗？你可以用csv做同样的事情。

是的，必须是一个哈希作为脚本然后读取文本文件。可以这样做......即所以输出不是逐列而是读取的方式？我已经尝试过寻找解决方案但是已经画了一大块空白。

如果选择文本文件格式，可以从导出向导中选择要使用的分隔符。

Hi,

Not sure if this is the right place to post this query so apologies in advance.

I have two columns in an access table.

Example for 2 records:

Field 1 - Retail
Field 2 - Sat
Field 1 - Direct
Field 2 - Sun


Can someone tell me how you output this as a sequential file? So the text file reads Retail#Sat?Direct#Sun? ...so that a hash is inserted after field 1 and a carriage return is entered after field 2.

Any help would be appreciated.

解决方案

Does it have to be a hash? You could do basically the same thing with a csv.

Does it have to be a hash? You could do basically the same thing with a csv.

Yes, has to be a hash as a script then reads the text file. Can this be done...i.e so the output is not column by column but reads across the way? I have tried looking around for a solution but have drawn a big blank.

You can choose which delimiter you want to use from the export wizard if you select the text file format.

这篇关于将数据导出到顺序文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！