transfering data from excel to access??

V

vicky

Hello
I was just wondering if its possible to somehow copy the table content from
Excel and paste it into Access? Since I have a lot of information in the
table, it would take me forever to enter the information in one record at a
time.
Thanks
 
F

fredg

Hello
I was just wondering if its possible to somehow copy the table content from
Excel and paste it into Access? Since I have a lot of information in the
table, it would take me forever to enter the information in one record at a
time.
Thanks
Click to expand...

You can use the TrasnsferSpreadsheet method to import your spreadsheet
data using code. See VBA help files.
or ....
simply click on File + Get External data + Import.
Follow the import wizard instructions.
 
Top