Exporting an Excel data to MS Access

[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. 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.

 

[Nick Hodge]

Would it be no good to link the excel sheet to the Access database, via
File>Get external data...>link tables in Access. This way your current data
would always be available to Access queries, reports etc.

Alternatively, I would set up an append query in Access from this Excel
sheet

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England

(e-mail address removed)
www.nickhodge.co.uk

 

[CAM]

Thanks Nick,

That's a good thought I think I will give that a go.

Cheers