Ms Excel:Import table in Excel to Access

[141980]

Hi,

Just want to ask..whether is it possible for me to create a table in ms excel then by the same time i create a table automatically in ms access via odbc?i just asking if there any solution for this problem.

 

[xlbo]

Just link the table in Access

Create your spreadsheet then goto Access
Tables view
New>Link Table
Select MS Excel for the data source and browse to your file....

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question