problem when converting vb6 to .net

[lee82]

Goodday,

I am looking for a program that will take data from excel and import it to access.
(using '97)

i found an example but it was don in vb6. when i try to convert it to .net, i get an error message stating that EXCEL9.OLB is needed to successfully convert. I looked in the folder where it is supposed to be, and i only have an EXCEL8.OLB file.

What is this file, and how do i get it?

Otherwise if there is a vb.net example to do this, i would appreciate it if someone can point me in the right direction.

thank you

lee

 

[kulrom]

That is Microsoft Excel 9.0 Object Library for which the default location is
the C:\Program Files\Microsoft Office\Office\Excel9.olb
In your case you should update EXCEL8.OLB to EXCEL9.OLB ... Cheers

 

[lee82]

thanks for replying.

How do i do that?

lee

 

[kulrom]

Replace winexcel.exe with one of the following downloads (try them all, if necessary):
1. Excel 97 version of winexcel.exe (Excel 8.0 Object Library)
2. Excel 2000 version of winexcel.exe(Excel 9.0 Object Library)
3. Excel 2002 version of winexcel.exe (Excel 10.0 Object Library)

If none of these work, choose the one that seems as though it should work, and download the diagnostic version:

4. diagnostic Excel 97 version of winexcel.exe (Excel 8.0 Object Library)
5. diagnostic Excel 2000 version of winexcel.exe(Excel 9.0 Object Library)
6. diagnostic Excel 2002 version of winexcel.exe (Excel 10.0 Object Library)

After running the diagnostic version, email c:\winxllog.txt to winsteps.com - together with a brief description of the problem.

Cheers

 

[TPM]

You can import straight into Access; goto new, import table, select type .xls then select the file you want to import. I'm working in 2002 so it maybe a little different, but you should still be able to do it.