Using offset flat files with ADO

Evil Phil · 2004-06-22 09:41:39

Folks I have a dat file which I want to import into an Access database using ADO 2.5(via a vb6 front-end). This wasn't a problem initially as the file was delimited but the provider has changed the file format to use offsets. I can no longer use simple SQL to import it. Does anybody know how to import an offset file…

22-06-2004 09:41AM

#1

Evil Phil

Registered Users, Registered Users 2 Posts: 7,468 ✭✭✭

Join Date: March 2001

Posts: 6624

Folks I have a dat file which I want to import into an Access database using ADO 2.5(via a vb6 front-end). This wasn't a problem initially as the file was delimited but the provider has changed the file format to use offsets. I can no longer use simple SQL to import it. Does anybody know how to import an offset file through ADO?

0

Comments

#2 22-06-2004 10:52AM

Evil Phil

Registered Users, Registered Users 2 Posts: 7,468 ✭✭✭

Join Date: March 2001

Posts: 6624

I've decided to delimit the file myself (using the FileSystemObject library) and then import it using my original method. Just in case your wondering ...

0
#3 22-06-2004 01:32PM

bonkey

Registered Users, Registered Users 2 Posts: 15,443 ✭✭✭✭

Join Date: April 2001

Posts: 14635

Phil..

you can do it using the ADO text file driver, but you need to configure a schema file.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcjetschema_ini_file.asp should give you all you need for future reference.

0