
Excel spreadsheet from an Access database using VB?
I am trying to create an Excel spreadsheet from an Access databse using
VB. My program opens an existing database, creates a new table from some
external, data text files and then fills a DBgrid with the new database
table. I am trying to build the spreadsheet by referencing individual
cells from specific DBgrid columns, but I am getting hung up on the
commands to do this. It appears that one would use the Column.name and
ColIndex properties. I've tried to search the Knowledge Base, but the
servers din't seem to working last night or this morning.
An alternative is to use OLE to have Excel open a new file directly from
the Access database, but of course, that's rather beyond me at this point
also.
Any help or suggestions would be greatly appreciated.
Thanks,
Matt
So far I have been unsuccessful