Sign in to follow this  
Followers 0
PoojaKrishna

Import information from text file to Access database.

4 posts in this topic

Hi friends,

Is there any faster method to import information from a text file to an Access data base, other than, reading each line of text file, splitting it and inserting into the table?

Regards,

Pooja.

Share this post


Link to post
Share on other sites



#2 ·  Posted (edited)

Importing it using the import feature on Access.

I'm sure there is an ADO method, but I do not know how...

Edited by foster74

Share this post


Link to post
Share on other sites

Importing it using the import feature on Access.

Thanks for the reply.

Is there any ADO method for doing that directly from my script?

Pooja.

Share this post


Link to post
Share on other sites

#4 ·  Posted (edited)

Pooja, You can using the ADO text driver.

If your text file is CSV or other delimited file you could try using this as the connection string:

"Driver={Microsoft Text Driver (*.txt;*.csv)};Dbq=" & $FileLocationAndName & ";Extensions=asc,csv,tab,txt;"

Edit: to correct Conn. String.

Thanks for the reply.

Is there any ADO method for doing that directly from my script?

Pooja.

Edited by DaRam

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0