Appending data from an Excel spreadsheet

[CAM]

Hello,

I wonder if this can be done. I have spreadsheet that I want the data to be
exported into MS Access via a command button on the Excel spreadsheet or
from MS Access. I only want the data to be appended to a table in MS Access
2003 not exporting to a new table. Can this be done. I don't know where to
begin. Any tips or website to visit will be appreicaited. Thank you in
advance.

 

[John Vinson]

Hello,

I wonder if this can be done. I have spreadsheet that I want the data to be
exported into MS Access via a command button on the Excel spreadsheet or
from MS Access. I only want the data to be appended to a table in MS Access
2003 not exporting to a new table. Can this be done. I don't know where to
begin. Any tips or website to visit will be appreicaited. Thank you in
advance.

I'm sure it can be done from either application, though I have only
done so from Access. You can use the TransferSpreadsheet method in a
VBA Module (called a Macro in Excel), specifying the spreadsheet
parameters and the target table name. Take a look at the VBA Help for
"TransferSpreadsheet".

John W. Vinson[MVP]

 

[CAM]

Thanks John

I'm sure it can be done from either application, though I have only
done so from Access. You can use the TransferSpreadsheet method in a
VBA Module (called a Macro in Excel), specifying the spreadsheet
parameters and the target table name. Take a look at the VBA Help for
"TransferSpreadsheet".

John W. Vinson[MVP]