Post by J » Wed, 16 Jul 2003 02:15:43

Using Aceess 2000, VB6 (SP5), ADO

I would like the easiest (of course) and most efficient method to create an
excel file and insert data into it from an access db.
I am running a quarterly report. I connect to the access database then pull
the records that fall with in the quarter (I already know how to do this
part). Next I want to be able to put that data into the excel file (already
using a text file).

Can I simply insert the record set into the excel file and have excel
calculate the "taxes" column?

Or should I calculate the "taxes" with vb and insert the answer into excel?

How do you open a new excel file?

Or, should I use some type of excel grid (if there is one) to display the
results to the end user and then give them the opprotunity to save it to
file it they want to?

A lot of questions...need some help and code examples if you got them....



Post by jc » Tue, 23 Sep 2003 08:09:05


I have been working for a while with VB 6 and Access 2000. Just today I
started hetting this new error.
"Unrecognized database format".
I knwo what this means but...what does this mean?
On MS's website I have found that this happens when upgrading from previous
version sof access.

Can anyone help me




Post by Fran » Tue, 23 Sep 2003 15:12:57

Install Service Pack 5 of VB6

If you work with DataControl you can select Connect ="ACCESS" or "ACCESS
Best is to add (components) the MS ADO DataControl when you work on a
2000/2002 Access db.



Post by Bernard Ki » Wed, 24 Sep 2003 02:07:57

Probably your MDB file is too large or got damage. You
need to rebuild MDB file by using ACCESS database utility.


Post by Val Mazu » Wed, 24 Sep 2003 10:57:47


Is it same code which was working before? If yes, then try to compact
database. It could be corrupted. You could use JRO library to do it from VB
code. See next KB with example ;EN-US;230501

If you have changed you code, then check your connection string. To be able
to connect to Access 2000 database you need to use Jet 4.0, not Jet 3.51

Val Mazur
Microsoft MVP
Check Virus Alert, stay updated