Excel to Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can you link Excel to an Access table(s) and update the table(s) from Excel?

If so where do I start looking? I have seen in Excel that can link to database using MS Query, but cannot see a way to update Access table from within Excel.
 
As long as the worksheet is laid out with columns like an Access table, you
can link directly to it. Choose File ... Get External Data ... Link ... then
change the file type to Excel. Now the table is the Excel worksheet and can
be queried from within Access exactly like an Access table, and updated
directly from Excel.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

Neil Hiorns said:
Can you link Excel to an Access table(s) and update the table(s) from Excel?

If so where do I start looking? I have seen in Excel that can link to
Click to expand...
database using MS Query, but cannot see a way to update Access table from
within Excel.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access #Error & Excel Pivot 0
Linked Excel File won't update 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Changing Links to access databases 1
Access to Excel link 2
Insert Into a SQL table via Access 2007 8
Importing Excel file without server access 3
Counting multiple memberships 1

Back
Top