by "Douglas J. Steele" <NOSPAM_djsteele@[EMAIL PROTECTED]
>
Nov 30, 2008 at 11:02 AM
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 im****t it: you use
TransferSpreadsheet, but with a TransferType of acLink rather than
acIm****t.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
"Denver" <Denver@[EMAIL PROTECTED]
> wrote in message
news:CAFC9C5A-C9A7-4E69-B9FB-45E1E535041A@[EMAIL PROTECTED]
> Hello,
> on weekly basis our client submit a re****t on excel sheet.
> would it be wise to im****t it every week?
> if im going to im****t 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 re****t. can this be possible? how to accomplish this?
> can anyone help me.
>
> thanks
>
