We have an Access application with a SQL Server database for a testing laboratory. We are importing text files from an Agilent ICPMS instrument (sample attached). The Sample Name column is a text field of the format wwww-xxx-y. That matches a primary key in a main table in the SQL Server database. Examples:
1409-002-01, 1409-013-1, 1409-096-1. The first two look like dates to ADO and it reformats the data as such.
We're using this connection info:
ta Source=" & strPathToTextFile & ";Extended Properties=""Text;HDR=YES;
objRecordset.Open "SELECT * FROM [" & ThisFileName & "]", objconnection, adOpenStatic, adLockOptimistic, adCmdText 'select all text lines from the file
I have tried renaming the file as .txt. Same problem.
How can I force ADO to NOT HELP with interpreting the Sample Name values as dates?