S
Stockwell43
Hello,
I am trying to help someone in another area to use information from an
access table that is received by a vendor and dump it into an excel
spreadsheet. I need help in either doing this another way or help with coding
to make this work and any and all ideas and suggestions are welcomed!!
1. I was going to create a database as a shell and import the necessary
table from the access database from the vendor.
2. I am going to create a simple query to extract the fields needed to
export to the spreadsheet using the DoCmd.TransferSpreadsheet.
Here is what I need help with:
1. Can I somehow create a form with a button that will automatically import
the table from the vendor database and replace it with the old table that was
import the day before?
2. Can I have a button that when clicked will delete the old information and
run the query to pick up the new data from new table and then another button
to export that into the same spreadsheet?
Thanks!!!!
I am trying to help someone in another area to use information from an
access table that is received by a vendor and dump it into an excel
spreadsheet. I need help in either doing this another way or help with coding
to make this work and any and all ideas and suggestions are welcomed!!
1. I was going to create a database as a shell and import the necessary
table from the access database from the vendor.
2. I am going to create a simple query to extract the fields needed to
export to the spreadsheet using the DoCmd.TransferSpreadsheet.
Here is what I need help with:
1. Can I somehow create a form with a button that will automatically import
the table from the vendor database and replace it with the old table that was
import the day before?
2. Can I have a button that when clicked will delete the old information and
run the query to pick up the new data from new table and then another button
to export that into the same spreadsheet?
Thanks!!!!