Dennis_Treacy
asked on
Import text file using Jet Engine when mixed integer and string values in field
When importing text files with Jet and most values in a filed are integer, the string values in that field are omitted. A similar problem occurs with Excel and the fix for Excel is to include IMEX=1 in the connection string. What is the fix for the text file connection? I am using Delhi 2007 for Win32
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
http://www.connectionstrings.com/?carrier=textfile
third sample of schema.ini
ziolko.