Export Excel to Access

[Guest]

How do I export and excel spreadsheet to an Access Table?

 

[Guest]

How do I export and excel spreadsheet to an Access Table?

You want to Import the spread sheet from Accress.

Save and close your spreadsheet.
Open your database, and from the File menu, select Get External Data\Import
and follow the prompts.

Hope this helps
Rosco

 

[Jamie Collins]

You want to Import the spread sheet from Accress.

I saw 'export to' rather than 'import from' <g>.

In EXCEL, choose: Data, Import External Data (ignore, for the moment,
the fact is says 'Import'), New Database Query, select an appropriate
data source (e.g. 'MS Access*'), OK, select the database, close the
Add Tables dialog and you should now be in MS Query. Choose: View, SQL
and type your code e.g.

INSERT INTO MyTable (MyIntCol, MyTextCol) VALUES (55, 'Fifty-five');

Hit OK, OK to the message about displaying sql 'graphically' (whatever
that means) and you should get a message such as, 'Executed SQL
statement successfully: 1 rows affected'.

If you prefer code, you can use ADO and the OLE DB provider for Jet in
Excel VBA code.

Jamie.

--