I have an access database that marks quite a few records for export to a CSV file. The customer requires a CSV file for electronic upload to their billing system. However, EACH, record must have it's own CSV folder. Each folder must be names with the ticket number and date of the record.
我有一个访问数据库,标记了很多用于导出到CSV文件的记录。客户需要CSV文件才能以电子方式上传到其结算系统。但是,每个记录必须有自己的CSV文件夹。每个文件夹必须是包含票号和记录日期的名称。
I would like to export all records marked for export to the CSV in a batch. Then, programmatically move through the records and move each ticket to the separate CSV file...with the unique name.
我想批量导出所有标记为导出的记录到CSV。然后,以编程方式移动记录并将每个票证移动到单独的CSV文件...具有唯一名称。
Any ideas? I'm stumped and have been working on this/searching the internet for months.
有任何想法吗?我很难过,几个月来一直在研究/搜索互联网。
1 个解决方案
#1
0
If you are doing it all in Access, you don't need to do it in two steps, you can create a file from each row in a loop.
如果您在Access中完成所有操作,则无需分两步完成,您可以从循环中的每一行创建一个文件。
#1
0
If you are doing it all in Access, you don't need to do it in two steps, you can create a file from each row in a loop.
如果您在Access中完成所有操作,则无需分两步完成,您可以从循环中的每一行创建一个文件。