Re: excel to access

Thanks for this idea Mr. Douglas J. Steele
But for now what would be the first thing to do?
do i need to im****t one of my excel to access? what is next after this?
i have a form now with a button Re****t. I am planning that this button
will tell access to im****t this Excel to Access then access will do 
automatically pass to query and then to re****t. Can you give me idea how
to 
start my VBA codes?

thanks again

"Douglas J. Steele" wrote:

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