Automatic import

A

Andlis

HI!
I need to import data from an Excel97 workbook into an
Access97 database. The Excell file always has the same
name, is in the same place and contains the same colums
and type of data. The data must override the old table.
Is it possible to import this data in full-automatic mode
through a button?

Thanks a lot!

Andlis
 

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 0
Importing import specs 0
Importing data from Excel into an existing Access table? 1
importing multiple worksheets from excel to access 1
Import excel file automatically that results in 2 tables 1
Help with selective import from Excel. 2
Can you automatically delete import error tables using a macro? 1
Import Multiple CSV Files from Same Folder into Open Workbook 5

Top