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

Matt, on Microsofts VB page, there is a section on downloads.
there is an excellent Access to Excel program with source code.

I also wrote a Access to Excel program, it would open a Access
database and then using SQL selects all row/records and builds  
an Excel spreadsheet.  Would be glad to send it to you,
but its at work, so let me know.

Joe K0BX
McDonnell Douglas Information Systems

Thank you,

Dean C. Pickett