Thanks Chris.
That worked perfectly with what I was doing, now I am on step 2 of trying to have the code open these text files in excel. I am thinking about using something along the idea below, but am still struggling. If you have any suggestions, it will be helpful.
Dim ApExcel As Object
Set...
Hi,
I am new to all this and exporting to excel from access is the problem I am having. Here is what I would like to do.
I would like to
1. EXPORT out an ACCESS TABLE as a TAB DELIMINATED file
2. OPEN the TAB DELIMINATED file as an EXCEL file
3. SORT the EXCEL file by a field
Ideally, I would...
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.