Transfer Spreadsheet – again (XP)

Topic

New Reply

This has been working OK in the past but now it gives me the error 2391 Field ‘FirstField’ doesn’t exist in destination table ‘tmpImport1’
DoCmd.TransferSpreadsheet acImport, , “tmpImport1”, strFileName, True
The table does not exist but this line of cade was working and creating the table I’m sure of it, any ideas?

Reply | Quote

Replies

Found the problem – somehow I had a query named tmpImport1. but here’s another one, and I’m ashamed to say that I used a macro for the first time in ten years, to get around it, but the macro is not flexible enough.

‘ Import the text file using the specifiction
varSessionAttendanceScan = “SessionAttendanceScan”
DoCmd.TransferText acImportDelim, varSessionAttendanceScan, “tmpImportSessionAttendance”, strFileName, False

what is wrong with this line?

Reply | Quote

What is the error you get when you use this line?

Reply | Quote

The error was “Kent had a brain meltdown” The line I am actually having a probem with is –
strTable = “demographics”
DoCmd.TransferDatabase acImport, “Microsoft Access”, Me.txtLabelPath, acTable, strTable
This one error with runtime error 2006
The object name you entered doesn’t follow , object naming rules.

it looks like I left the destination object name off the end. Now it works. Bad day, lost the plot.

Reply | Quote

You haven’t specified a name for the target (the imported table). If it should have the same name as the source, you can use

DoCmd.TransferDatabase acImport, “Microsoft Access”, Me.txtLabelPath, acTable, strTable, strTable

Reply | Quote