Hi guys,
I need to import several excel files into Access, and merge those files in 1 file, the files are always different that’s why I can’t type the name of the fields on the routine to store the records in the merge table, the merge table have all the fields names the are in the imported excel files. Right now I am reading the imported files one by one, column by column, let say column 1 is ID I need store this value in the Merge Table that has a filed call ID, how can I do that without typing rs!ID = rsa!ID in my routine, because I don’t know the cell names in the imported excel files.
rs.AddNew
Do While …..
rs!MergedFieldName = rsa!importedExcelFieldName (this line is the issue)
Loop
rs.Update
Any help will be appreciated
Thanks
Orlando
I need to import several excel files into Access, and merge those files in 1 file, the files are always different that’s why I can’t type the name of the fields on the routine to store the records in the merge table, the merge table have all the fields names the are in the imported excel files. Right now I am reading the imported files one by one, column by column, let say column 1 is ID I need store this value in the Merge Table that has a filed call ID, how can I do that without typing rs!ID = rsa!ID in my routine, because I don’t know the cell names in the imported excel files.
rs.AddNew
Do While …..
rs!MergedFieldName = rsa!importedExcelFieldName (this line is the issue)
Loop
rs.Update
Any help will be appreciated
Thanks
Orlando