INSERT INTO Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello
This might not be the right group to post to if its not could someone get
me in the right direction. I would like to be able to use excel to Insert
new data
into an existing access table or Import the new data to an existing access
table.
I use excel to pull payroll hours and then I have manually enter the data
into my database

Please help
If I need to give more info please let me know

Thanks Mike
 
I'm not sure if you can "push" data with excel, but I believe you can "pull"
the excel data within Access. If it is always the same excel file I'd suggest
you link to the excel file using File>Get External Data>Link Tables. This
allows you to query or modify the original excel table. If you'd rather work
with a copy or the excel file changes names use Import instead. At this point
Access has another table which you can make queries/forms/reports just like a
normal Access table. If you want the data to be added to an existing Access
table build an append or update query moving the data from the imported excel
table into the Access table.

This all works in theory as I've not done this with an excel file before.
I've just done it with Access tables, but the Import lets you choose excel
tables as an option, so I don't know why it wouldn't work.
James
 
Thanks James
I'll look into your idea. I'm thinking that I can push the data into the
access table
I have read this somewhere just can't remember where

If anyone else has any suggestions please let me know

Thanks mike
 
Back
Top