Importing Excel files that are automatically updated into Access

  • Thread starter Thread starter PeterPfaffJCI
  • Start date Start date
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
 
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 File into EXISTING Access Table 2
Import Excel 2010 table into Access 2010 - not listed as range 1
Automatically Importing Excel data into Access without link 1
Importing data from various file formats into Access 1
Automatically Importing Excel data into Access 6
Access #Error & Excel Pivot 0
Import Several excel files into Several Access Tables 6
Set up Automatic Unattended Security Updates on Ubuntu 18.04 or Mint or any Debian. 6

Back
Top