Exporting an Excel data to MS Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CAM - 18 Nov 2006 02:23 GMT

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.

Reply to this Message

Nick Hodge - 18 Nov 2006 10:27 GMT

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

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England

nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS
www.nickhodge.co.uk

> Hello,
>
[quoted text clipped - 3 lines]
> 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.

Reply to this Message

CAM - 18 Nov 2006 17:53 GMT

Thanks Nick,

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

Cheers

> 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
[quoted text clipped - 10 lines]
>> 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.

Reply to this Message

Rate this thread: