SteveCarrier
Programmer
Hello,
I am trying to transfer the contents of certain cells in a spreadsheet to fields in a database. The TransferSpreadsheet method works okay if your spreadsheet has large ranges of relevant data, but I am going to have to sift through the spreadsheet with some code to locate certain records and transfer them to the relevant tables one at a time. If anyone know of a command or series of commands in VBA which will allow you to transfer cells one at a time to specific fields within a database table I would be forever in your debt.
Thanks in advance.
Steve Carrier
I am trying to transfer the contents of certain cells in a spreadsheet to fields in a database. The TransferSpreadsheet method works okay if your spreadsheet has large ranges of relevant data, but I am going to have to sift through the spreadsheet with some code to locate certain records and transfer them to the relevant tables one at a time. If anyone know of a command or series of commands in VBA which will allow you to transfer cells one at a time to specific fields within a database table I would be forever in your debt.
Thanks in advance.
Steve Carrier