excel to access

  • Thread starter Thread starter Denver
  • Start date Start date
D

Denver

Hello,
on weekly basis our client submit a report on excel sheet.
would it be wise to import it every week?
if im going to import it every week my database would come up a bunch of
tables and queries.
is there any wise suggestion?
or i want to make a button that tells access to link and pass to queries and
then to report. can this be possible? how to accomplish this?
can anyone help me.

thanks
 
Linking to the spreadsheet and using the linked table as the basis for an
Append query might be your best bet.

You link to a spreadsheet virtually the same way you import it: you use
TransferSpreadsheet, but with a TransferType of acLink rather than acImport.
 
Thanks for this idea Mr. Douglas J. Steele
But for now what would be the first thing to do?
do i need to import one of my excel to access? what is next after this?
i have a form now with a button Report. I am planning that this button
will tell access to import this Excel to Access then access will do
automatically pass to query and then to report. Can you give me idea how to
start my VBA codes?

thanks again
 
Back
Top