If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

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…

Options

22-06-2004 10:41am

#1

Evil Phil

Registered Users 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

Options
#2 22-06-2004 11:52am
Evil Phil

Registered Users 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
Options
#3 22-06-2004 2:32pm
bonkey

Registered Users 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