This SQL query, that you wrote:
Code:
SELECT T1.*, 1 AS SheetSource FROM [Excel 8.0;HDR=YES;IMEX=1;Database=C:\Forum\LouReed\Sept21\Production Tracker.xlsx].[Expanded Tracker$A1:BA8] as T1;
Opens up the spreadsheet source and gives it some parameters.
Now to loop through the rows and loop through the columns, do I do that in VBA or SQL?
I am not sure what to do next. As I said above, I am unfamiliar working with recordsets.
When it comes times to eliminate row 1-4 on down ... delete row 4 should that be done in SQL.
All of the modifications of the Excel spreadsheet must be done before importing it to Access. If I do not do that then it will not import into Access correctly.
That implies that I must use SQL. I cannot use VBA (at least VBA for MS Access) until after I import the Excel spreadsheet.
So I must use SQL on the Excel spreadsheet before (or while) it is imported. Is this correct?
Sorry, if the questions sound dumb. I am quite to importing Excel into Access.
Any help appreciated. thanks in advance.
Respectfully,
Lou Reed