I have a local MS Access table used by inspectors in areas without Internet. I need to append 250 fields to remote MS SQL table when they return to office without duplicating current ID numbers. Must I list all 250 fields or can it be accomplished using *? I've attempted various forms of the following without success:
Following the connection string:
strSQL1 = "INSERT INTO dbo.dams_inspection_" & PCUser & "" _
& "SELECT * FROM dbo_dams_inspection;"
Set td = CurrentDb.TableDefs("dbo_dams_inspection")
--followed by other procedures for retrieving current data from remote server