I discovered on another web site that if the sheet name is "January Sales" then the SourceTableName would be "January Sales$" with the $ necessary. It works in the application I am working on, so the help file in Access is less than exact in this respect.
essnrv,
I am trying something similar to DIVINEDARO956, where I am trying to import the data from an Excel sheet into a temporary table for comparison to another table. I found the example you posted in the Access help files, but have one question - what exactly is "January Sales"? Is...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.