Hi Pammy,
I had a similar problem and found 2 solutions.
Solution 1:
In Excel you can can go to Data/Get external Data and set up a Query to your Access Database. This works Very well with a Spreadsheet that is formatted to look a certain way(ie. Line spaces etc.)
Solution 2:In Access /Macros...
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.