delete blank rows
I know VBA in Excel but am a total beginner with Access. A good portion of
my VBA programs start with the parsing or opening of a text file in Excel
and saving it as a .xls Excel file.
My problem is this huge 8meg 85,000 row text file(many blank rows) will not
fit in the 65,000 max Excel rows so it truncates. I guess I need the VBA
code so that in my Excel macro I could open an instance of Access then open
the huge text file, then delete the blank rows, then save it as an Excel
Once it fits in Excel I will be all set.
Any help would be greatly appreciated.
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center