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.
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.