export access97 to a text file

[dataloader]

Hi...old problem, but first time I've seen this forum...so can't hurt to try this question here. Every month I am given 50 tables in access97 and my job is to take the data and put it to a flat file for loading into a separate database. Well, when the columns contain numbers with decimal places of more than two, they are truncated to two decimal places in the exported text file. I know this is by design, but it's a dumb design...how do I get around this?

For now I have to save the access tables into EXCEL, and THEN save to text. Not pretty especially when some of the tables are more than 65500 rows and I have to split them up before saving them to excel.

Thanks for any help!

 

[Davepacey]

Can you not just import into new database from each access file ?

Dave

 

[dataloader]

No, the ODBC connection is too slow to export the data from 40 tables with some the number of rows in some tables around 200 000 in number.

Also, using Format([columnname],"##0.000000000")
as the field names is not suitable as there
are 60 columns in some tables.

THANKS for the help