Link to home
Create AccountLog in
Avatar of Dennis_Treacy
Dennis_TreacyFlag for Australia

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
Avatar of Lukasz Zielinski
Lukasz Zielinski
Flag of Poland image

take a look here:
http://www.connectionstrings.com/?carrier=textfile

third sample of schema.ini

ziolko.
ASKER CERTIFIED SOLUTION
Avatar of Lukasz Zielinski
Lukasz Zielinski
Flag of Poland image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer