I found the problem. Did not include the $. But this does not simply append the sheets but sorts them by row. Because of the PDF to Excel conversion, I have rows with no good reference that get sorted out of sequence. I will have to try VB.
Some is going wrong. I get to the point of SQL Query can't be selected..., press OK and receive the following message:
"Could not add the table "'N:\Test.xlsx"."Sheet1'"."
I started with a more complicated situation, but simplified it to see what the problem could be. My test file is simple workbook consisting of sheet1 containing text in the first 2 cells of the first 2 rows and second sheet where I want sheet1 to appear. My SQL statement is:
SELECT *
FROM "N:\Test.xlsx"."Sheet1"
My answers
I found the problem. Did not include the $. But this does not simply append the sheets but sorts them by row. Because of the PDF to Excel conversion, I have rows with no good reference that get sorted out of sequence. I will have to try VB.
Some is going wrong. I get to the point of SQL Query can't be selected..., press OK and receive the following message:
"Could not add the table "'N:\Test.xlsx"."Sheet1'"."
I started with a more complicated situation, but simplified it to see what the problem could be. My test file is simple workbook consisting of sheet1 containing text in the first 2 cells of the first 2 rows and second sheet where I want sheet1 to appear. My SQL statement is:
SELECT *
FROM "N:\Test.xlsx"."Sheet1"
I am using 64 bit Office 2016 on win 7 pro 64 bit
Thanks for any insight.
Duncan