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

Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

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 9: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 1: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