uplinking excel data

Z

zaps

Hi there,

I have alot of data on an excel spreadsheet, how can i uplink that
information into an access table??


Thanks,
Michelle
 
Z

zaps

Thanks for the help. So now I got my table compiled from the excel sheet,
is there a way i can make a button to perform what i need to do in order to
keep adding new info from the excel sheet to the existing table, instead of
choosing file etc.

Each month, old data is deleted from the excel sheet (after being transfered
to access), and new data is entered. Each month i would like to be able to
transfer the info from the excel sheet over to a table in access. Can I make
a button? Or use a Macros?

Thanks,
Michelle
 
J

Jackie L

It sounds like you will need to append the data to your existing table instead of creating a new separate table. If that is the case, import your data into a temporary table and create an append query to put those records into your existing table. Otherwise, you may want to still use the append query even if it is a new table because you can have the table field properties and relationships without having to recreate each time. Either way, if you are not familiar with VBA code then you can automate the import routine in a macro by choosing Transfer Spreadsheet and choosing import and the file type and name below. Attach the macro to a button on your form

Hope this helps

----- Joseph Meehan wrote: ----

zaps wrote
Thanks for the help. So now I got my table compiled from the exce
sheet, is there a way i can make a button to perform what i need t
do in order to keep adding new info from the excel sheet to th
existing table, instead of choosing file etc
transfered to access), and new data is entered. Each month i woul
like to be able to transfer the info from the excel sheet over to
table in access. Can I make a button? Or use a Macros
Michell
Click to expand...

Sure can. However I am a little fuzzy on it right now and maybe someon
else will offer to help and I am sure they would make more sense than
would

If no one comes forward in a few days post again to remind me and
should have time to play with it a little
 
Top