Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Linking a csv file to an existing access table.

Status
Not open for further replies.

thetambarineman

Technical User
Feb 29, 2000
63
GB
Hello all,

This is a seemingly complex problem.. Basically i want to import a csv file from Excel and import it into an existing table - called dbemployer.

Ive researched a few ways but they havent worked....

Any help would be greatly appreciated!

Thanks in advance

Paul
 
The simplest weay to do this if you want to do it a single time is to do it from Access.

Just go to Access\File\Get External Data\Import and choose the Excel file. Then you should be able to see the columnnames in an import-wizard.

If you are planning to do this on a regular basis, I would suggest that you create a macro in Access that does the exact same thing.

Good Luck!
-Mats

 
Ms Access. Macro. UGH. NO! Bad%$%#%$#%$!

Do it w/ vba code. At least you can trap the errors.

MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over
 
Thanks for your replies..
I mulled over this all last nite then went back in this morning and worked it out in 3 lines.

Dim acc as new access.application

acc.opencurrentdatabase "C:\program files\agswe\system files\workexp.mdb", false

acc.docmd.transfertext acimportdelim, Import, "dbemployer","a:\L6WE.csv",1

And thats all there is to it!! Great! :)

Thanks again...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top