Importing Excel files that are automatically updated into Access

P

PeterPfaffJCI

I am in the process of creating a data base where I have some existing files
in Excel that are automatically updated from an AS 400 query. If I link the
tables will the update take place when I open Access? Or is there a command
that will ask Excel to up date when run?

Pete
 
K

Ken Snell \(MVP\)

Linked tables in ACCESS automatically update when you open or read the data
from the tables. So the answer to your question "If I link the
 

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

Import Excel 2010 table into Access 2010 - not listed as range 1
Access #Error & Excel Pivot 0
Running Make Table Access Queries from Excel 3
'Datalinking' Access and Excel 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Excel Import External Data by Date Automatically 0
Import Excel File into EXISTING Access Table 2
Automatically Importing Excel data into Access without link 1

Top