Not sure if I am asking this correctly or not but here goes....
There are a lot of examples of DoCmdTransferSpreadsheet acimport out there
but haven't found one that answers my question.
What I would like to do is have the user click a button on a form and then have
this command import a spreadsheet into a table.
After the table is created, I would like to open another form that uses a query that accesses
the table that was just created for populating the fields on the form.
So this is something of what comes first, the chicken or the egg...
So if my command looks something like this:
DoCmd.TransferSpreadsheet acImport, 8, "NewData_tbl", "C\Staging\SalesOrderReport.xlsx", True
Will this command over write an existing table named NewData_tbl?
Otherwise, how would I set up the form and query for a table that does not exist yet,
or do I create a table with the query and form?
Thanks
There are a lot of examples of DoCmdTransferSpreadsheet acimport out there
but haven't found one that answers my question.
What I would like to do is have the user click a button on a form and then have
this command import a spreadsheet into a table.
After the table is created, I would like to open another form that uses a query that accesses
the table that was just created for populating the fields on the form.
So this is something of what comes first, the chicken or the egg...
So if my command looks something like this:
DoCmd.TransferSpreadsheet acImport, 8, "NewData_tbl", "C\Staging\SalesOrderReport.xlsx", True
Will this command over write an existing table named NewData_tbl?
Otherwise, how would I set up the form and query for a table that does not exist yet,
or do I create a table with the query and form?
Thanks