I've been learning about that myself recently. I will tell you what I know (which isn't a lot).
If you just want to do it once or twice, you should convert your spreadsheet to a CSV (comma separated values) text file. You'll find that under the saving options in your save dialogue.
Then just...
My experience in VBA is intermediate, but my familiarity with MS Access (while growing every day!) is still lacking. I learned in excel, and have only been using access for a month and a half.
I am trying to create a function that creates a recordset when certain parameters are passed to it...
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.