Help with transferring data from excel to access.

[phong.lee]

Hello all, i'm new at this. I need some assistant in transferring data
from excel to access.

I created a macro that basically gather all the necessary data that i
need to bring into access. I also created a table in access with the
correct columns to store the data from excel. Is there a way in VBA
code that i can write so that when the data that i need can be
automatically transfer into my access table?

Thank you

[pietlinden]

how about running it once manually File, Get External Data, Import,
.....
and then after that naming and saving the Import Specification. After
that, you can use the import spec in a macro/code to run future
imports...

[phong.lee]

[e-mail] wrote:

how about running it once manually File, Get External Data, Import,
....
and then after that naming and saving the Import Specification. After that, you can use the import spec in a macro/code to run future
imports...

When my macro is finish running, i want to copy one column and save it
as a text file in excel vba. Can someone show me the right way of
doing this? Thank you.

[pietlinden]

copy one column from where? Guess it doesn't matter if it's a linked
SS. Just use TransferText and export the thing. See the help for
details/examples.

Macros? Never use them. (Yeah, but you gotta start somewhere.)