Hi,
I am trying to import a table into SQL using VBA.
What I want to do is loop through each row taking all the data then import this into SQL.
I could define each column but using:
Currentrow = 2
term1 = sheet1.cells(currentrow, 2)
term2 = sheet1.cells(currentrow, 3)
term3 = sheet1.cells(currentrow, 4)
Etc however I have 52 columns so was hoping there would be a smarter way of doing this.
Attached is a sample of my work:
sample7.xlsx
Thank you for any help.
Bookmarks