Excel spreadsheet from an Access database using VB? 
Author Message
 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



Fri, 28 May 1999 03:00:00 GMT  
 Excel spreadsheet from an Access database using VB?

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



Fri, 28 May 1999 03:00:00 GMT  
 Excel spreadsheet from an Access database using VB?

Quote:

> 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

I would be interested in this. If you could send me a copy to

Thank you,

Dean C. Pickett



Mon, 31 May 1999 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. linking an excel spreadsheet to an access database using vb

2. Importing Excel Spreadsheet into an Access 2000 Table using VB

3. linking an excel spreadsheet to an access table using vb

4. Using an Excel Spreadsheet as Database

5. VBA, Excel spreadsheet to Access Database

6. Converting Excel spreadsheet to Access database

7. linking an excel spreadsheet to an access database from vb6

8. Accessing Excel Spreadsheets as a database

9. Open excel spreadsheet from within Access using VBA

10. Accessing an Excel spreadsheet using ASP

11. Spreadsheet in VB 6 without using Excel

12. Export tables to Excel Spreadsheet using VB

 

 
Powered by phpBB® Forum Software