problem when converting vb6 to .net

lee82

New member
Joined
May 6, 2005
Messages
2
Location
Pretoria, South Africa
Programming Experience
1-3
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

Well-known member
Joined
May 10, 2005
Messages
2,854
Location
Republic of Macedonia
Programming Experience
10+
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

Well-known member
Joined
Dec 7, 2004
Messages
623
Location
CA
Programming Experience
3-5
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.
 
Top Bottom