Im having prblems linking a dat file. I have to link five files to My Access 2000 mdb. to do an extraction. 4 of the files are coming over fine but one file called qcldmicr.dat does not. We think some patches where made to the AMSI software to process this file. Because of this we have to use a amsiutil.exe to save the file as a .txt and import it in. Any suggestions on the problem so we could possibly avoid this step?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
File cannot be linked via ODBC drivers
- Thread starter shanester
- Start date
Sometimes data types can cause a problem. If the one file has a datatype that the ODBC drivers do not like. Also the file description contained in the file.ddf can cause a problem if you have any special characters including periods. You can take a look at the file description and the different data types using BtSearch at Gil
- Status
Similar threads
- Locked
- Question
- Locked
- Question