Import Module Code Bug Problem

[June7]

No, import into existing table is what I suggested. But I did suggest just using a query to export desired records/fields. But if you have no need to retain records, then purge is okay. It was the approach of repeatedly creating and deleting table objects I found troublesome.



Are there multiple simultaneous users? Is this a split design db?

[Ace2014]

No, import into existing table is what I suggested. But I did suggest just using a query to export desired records/fields. But if you have no need to retain records, then purge is okay. It was the approach of repeatedly creating and deleting table objects I found troublesome.

Are there multiple simultaneous users? Is this a split design db?

Well, I'm an intern. I'll be leaving July 17th, so I need to have this done by then. This is a huge task. I'm focusing on making it as simple and specific as possible.
My vision is to have this the sustainable knowledge database on sharepoint and to allow for multiple users at the same time.
But I'm thinking as of right now, that goal might be a little too difficult and they'll only be able to use it one at a time. Thoughts?

I haven't tested it with lots of data yet, but based on the theory, I should be doing it correctly. The only thing now standing in my way is exporting queries directly to any current user's computer.

Thanks for the advice, I think that having the table exist and that appending and deleting the data is easier than creating a new table each time. I was experimenting.
I added the table and will add a delete query after it.

Now, I'm having trouble now exporting the queries to any user's computer. Here's the code I have for it as of now:

Private Sub CommandCumulativeBench_Click()

'Query allowing user to upload data
Call Upload_PPNBench
DoCmd.Requery (qry3a_Select_PPNBench)
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qry3a_Select_PPNBench", CurrentProject.Path & "\xyz.xls, True"
'Query delecting tables contents
DoCmd.Requery (qry3b_Select_PPNBench_dlt)
End Sub

Any recommendations, do you need more info?

[Ace2014]

I think I figured it out
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qry3a_Select_PPNBench", CurrentProject.Path & "\xyz.xls, True"
replace with "xyz.xlsx", True