import data to Access table thru VBA

[krishnarao]

I want to import data from *.txt file to a table in access. i want to accomplish this through VBA not by wizard.

Advance Thanks for any suggestions and solution

 

[KenHigg]

Why the mad face thingy?

 

[Moniker]

There are lots of ways to do this in code. The simplest is DoCmd.TransferText. Look that one up in Access Help. It's not super-flexible, but you didn't really describe anything in detail, so it may very well suit your needs just fine.

 

[Call_Me_Sam]

no idea Ken....

krish.. i gues syou want to use something like

[COLOR="Lime"]docmd.TransferText[/COLOR] acImportFixed/acImportDelim,,"table to which to import to","Text file to import", "Has it a title row?"

The green is code, you change the rest accordingly./..Hook it all up to a button and should work..and no more mad faces..it scares Ken

 

[boblarson]

As Moniker has suggested, use Transfer Text, but you may want to set up an Import Specification so that you can define everything the way you want.

See my website here

http://www.btabdevelopment.com/main...teanImportSpecification/tabid/98/Default.aspx

for how to create an Import Specification.

 

[Call_Me_Sam]

bob, just looked at your tut on spec..could you then use the saved spec in the parameter field for the transfertext?

 

[boblarson]

bob, just looked at your tut on spec..could you then use the saved spec in the parameter field for the transfertext?

Yep, you sure can. That's what it is there for

 

[Lukas Pohnan]

Import Excel table into access table

I need to create a command button in an Access form and build VBA code to make the button import a column of data from an Excel file into a table in access.

Could someone please give me an example or tell me the code to do this?