Microsoft Access Schema.Ini file

[Martynt74]

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?

 

[andshrew]

I've recently upgraded to 2010 as well but this function still seems to be the same for me.

Do you mean you exported tables through the Access UI or through VBA?

If I right click a table, click Export->Text file it brings up a window to set the file name. Enter the file name, make sure Export data with formatting and layout isn't checked and then after clicking OK the Export Text wizard starts up. You can then go into advanced and set the delimiter and text qualifier as before.

 

[Martynt74]

Ah so it does! Not sure why that didn't seem to work for the when i first tried it.

Just created my spec so will update my Form which automatically creates the text file