I’ve recently upgraded from Access 2003 up to Access 2010 at work.
One function I used was to export tables as a text file. When doing so it allowed me to adjust how I wanted the text files to export and I could choose to change them from using a comma to separate columns to a pipe and also to remove speech marks.
I can’t seem to find anything in the current version of Access. I’ve googled and found the following
http://social.msdn.microsoft.com/Forums/pl/isvvba/thread/6a7ddcd5-ae4f-46d0-91e9-743ebf1b01eb
This is where I started to get a little confused. It seems that the schema.ini file specifies how a text file should look. However I could do with finding an example that I can modify as I’m struggling a bit.
I also saw that the schema file contains the reference to the text file to be changed. I tend to export text files which end with the date, therefore the output files will never have a recurring file name.
Does anyone have any info to help get me started?
One function I used was to export tables as a text file. When doing so it allowed me to adjust how I wanted the text files to export and I could choose to change them from using a comma to separate columns to a pipe and also to remove speech marks.
I can’t seem to find anything in the current version of Access. I’ve googled and found the following
http://social.msdn.microsoft.com/Forums/pl/isvvba/thread/6a7ddcd5-ae4f-46d0-91e9-743ebf1b01eb
This is where I started to get a little confused. It seems that the schema.ini file specifies how a text file should look. However I could do with finding an example that I can modify as I’m struggling a bit.
I also saw that the schema file contains the reference to the text file to be changed. I tend to export text files which end with the date, therefore the output files will never have a recurring file name.
Does anyone have any info to help get me started?
