How to load 1million records to Access

S

subbu

Hi,
I want to load the records from a falt file to
Access.Any tool available

subbu
 
V

Van T. Dinh

Access Import can import a CSV or similar Text file. If you want to use
code, use TransferText Method.

Check Access Help on Import and Access VB Help on TransferText.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to implement two shifts per day with multiple teams 0
Keeping to ms office 97 pro 0
Getting Radio Buttons to work, that are inserted via AutoText 0
Power Pivot. Yikes. 0
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Menu driven PowerPoint presentations 0
Ranked-choice poll in Outlook? 0
How to Create an S-Curve from Custom Field? 0

Top