Linking a csv file to an existing access table.

[thetambarineman]

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

 

[MatsHulten]

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

 

[MichaelRed]

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

 

[thetambarineman]

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...