Query to an Excel File

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

Guest

Hello

I have an excel file with a drawing number, drawing issue and deadline columns (and many more) that I recieve from my supplier. It get updated freakently but is always the same layout/format. How do I go about creating a query (I figured at least) that would cross reference the information in the Excel spreadsheet and the information contained in my Drawing Tbl (it has the same columns + many more). I want it to go through the record in the database and update the deadlines to reflect those in the Excel file. I would also like it to populate a table (not created yet) that would list all of the changes that it performed when the query is run thus contain drawing number, drawing issue, previous date and new date

Thanks a mil for all the help

Daniel
 
Suggestions to get you started....

Link the spreadsheet in the EXCEL file as a linked table in ACCESS. Write an
update query that will update the table based on values in the EXCEL
spreadsheet (you can join the spreadsheet as a table in the query, or you
can write a query to get the values from the spreadsheet and then use the
query to be a table, or you can use Domain functions (DLookup, for example)
to find data in the spreadsheet and use those values to update the table,
etc.). Then you also can write an append query that will write new records
into the "not yet created" table in order to "record/archive" the changes
made.

To give you more specific info, you'll need to provide more specific
details.

--
Ken Snell
<MS ACCESS MVP>

Daniel P said:
Hello,

I have an excel file with a drawing number, drawing issue and deadline
Click to expand...
columns (and many more) that I recieve from my supplier. It get updated
freakently but is always the same layout/format. How do I go about creating
a query (I figured at least) that would cross reference the information in
the Excel spreadsheet and the information contained in my Drawing Tbl (it
has the same columns + many more). I want it to go through the record in
the database and update the deadlines to reflect those in the Excel file. I
would also like it to populate a table (not created yet) that would list all
of the changes that it performed when the query is run thus contain drawing
number, drawing issue, previous date and new date.
 
Back
Top