Thanks for the info Ranman. I didn't try exporting the table directly. When importing I allowed Access to generate a key as it made my data manipulation much easier. I didn't want the generated key to show up in my export txt file so I was exporting a query result. I'll keep this tip in mind...
Hi,
I frequently have a need to import fixed width txt data into Access tables for analysis and have built many import/export specs to accommodate them. I recently had a need to import a 1300 byte record into Access so I could correct some specific data fields with the expectation to export them...
Hi,
My name is Don. I live in Rhode Island and started in IT 35 years ago as a mainframe dinosaur. I still pine for those days. :)
I have been using Access for data mining and analysis for about 15 years. I use a lot of ODBC connections for various data sources and import/export specs for...