asked on

How to import large text file into access db?

I have to import large text file(about 10 to 15 mb) into access database. The file is in fixed width format.
Each line contains one record. As it is not a simple "Just dump into" import but requires some intermediate calculations and updation into 4 different tables.
I have wriiten a project for this but it takes lot of time to finish the process and seems that computer is hanged up.
If anybody know any better strategy or a sleek way to do this then please let know.
I have asked this thing before also but didn't get any better suggestions.
Thanx a lot in advance.
Jzyo

deighton

Use a VB program to read the text file line by line using

open "file" for input as #1
while not(eof(1))
Input #1,sLine

'' parse data and save in Access .mdb

DoEvents
Wend

DoEvents means you can multitask in windows without locking the PC

ASKER CERTIFIED SOLUTION

vindevogel

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

khatrij

ASKER

I have to write it thru vb.
thanx for yer comments.

Moondancer

GREETINGS!

This question was awarded, but never cleared due to the JSP-500 errors of that time. It was "stuck" against userID -1 versus the intended expert whom you awarded. This corrects the problem and the expert will now receive these points; points verified.

Please click on your Member Profile and select "View Question History" to navigate through any open or locked questions you may have to update and finalize them. If you are an EE Pro user, you can also choose Power Search to find all your open questions.

This is the Community Support link, if help is needed, along with the link to All Topics which reflects many TAs recently added.

https://www.experts-exchange.com/jsp/qList.jsp?ta=commspt
https://www.experts-exchange.com/jsp/zonesAll.jsp

Thank you,
Moondancer
Moderator @ Experts Exchange