Refresh Data in database

G

Guest

At current I have a spreadsheet that is weekly produced, the content of this
spreadsheet is checked for errors etc, this is much easy and less manual to
do so through Access which I am starting to work towards.

I am trying to automate the importing of teh spreadsheet to Access, I know
that I can use a delete query to clear down the table and then re-import the
data when the spreadsheet has been re-ran, although cannot workout how to
automate the import part of the cycle.

Any tips/advice greatfully received.
 

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Import spreadsheet with modified date 1
Automate Import/Update of Database 2
Change Field Data Type? 1
Import text file data 2
Transfer Spreadsheet not importing all data 11
Field doesn't exist in destination table 0
Excel Import External Data by Date Automatically 0

Top