sharing Excel '03 data with Access

[alex]

Hello experts,

I'm attempting to convert excel data to an access database. I cannot
find the access add-in link that is available in previous versions of
excel, nor does it appear available from Microsoft's web site. Any
thoughts on the best way to covert without an add-in?

 

[MH]

The best way to get data into Access is to import it via Access rather than
pushing it from another app.

MH

 

[wjohnson]

Set-up your table in ACCESS to match the table in EXCEL - Then copy your
EXCEL table and paste it into your ACCESS Table.
In ACCESS you can also import your EXCEL table.
You can export your EXCEL document as a CSV file and then import it
into ACCESS.