copy data from external file

  • Thread starter יריב החביב
  • Start date
×

יריב החביב

Hello,

I know to bring to access an external file with the 'TransferSpreadsheet'
macro.

I know to copy data from table to table within access.

But I want, and don't know how, to copy data from external file (excel)

to a table in access.

Is it possible and how ???

thank you.
 
K

KumbiaKid

What you want to do is pretty easy. I'd suggest you link to the spreadsheet
rather than transfering it. Just go to the File menu, Get External Data, Link
Tables. Then in the Files of Type combo box, select Microsoft Excel .xls,
browse to your spreadsheet, follow the prompts and you'll see the spreadsheet
in your Access DB as a table. Notice that you can link either via a named
range (if you have any) or to the entire spreadsheet. You say you know how to
copy data from table to table in Access, so off you go. You can use either an
Append query or a Make Table query to move the data into an actual Access
table. Have fun!

KumbiaKid
 
×

יריב החביב

thank you
--
תודה רבה


KumbiaKid said:
What you want to do is pretty easy. I'd suggest you link to the spreadsheet
rather than transfering it. Just go to the File menu, Get External Data, Link
Tables. Then in the Files of Type combo box, select Microsoft Excel .xls,
browse to your spreadsheet, follow the prompts and you'll see the spreadsheet
in your Access DB as a table. Notice that you can link either via a named
range (if you have any) or to the entire spreadsheet. You say you know how to
copy data from table to table in Access, so off you go. You can use either an
Append query or a Make Table query to move the data into an actual Access
table. Have fun!

KumbiaKid
Click to expand...
 
Top