By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,505 Members | 1,517 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,505 IT Pros & Developers. It's quick & easy.

Help with transferring data from excel to access.

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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...

Nov 13 '05 #2

P: n/a

pietlin...@hotmail.com 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.

Nov 13 '05 #3

P: n/a
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.)

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.