Has anyone heard of method or tool to read an Excel 5 format xls file (or any other spreadsheet format, for that matter) within Visual Basic. I've seen several VBX's that provide spreadsheet type grid controls. Not what I want. I want to be able to read an Excel file into an access table (eventually). Any help?
Mon, 20 Jul 1998 03:00:00 GMT
Jens Balchen J #2 / 7
Reading an Excel 5 format into Visual Basic
reservoirs of wisdom:
Quote:
>Has anyone heard of method or tool to read an Excel 5 format >xls file (or any other spreadsheet format, for that matter) >within Visual Basic. I've seen several VBX's that provide >spreadsheet type grid controls. Not what I want. I want to >be able to read an Excel file into an access table >(eventually).
-- Everything I said are the opinions of someone else. I just cut-and-pasted.
Jens Balchen jr. http://www.sn.no/~balchen
Tue, 21 Jul 1998 03:00:00 GMT
Michael Pa #3 / 7
Reading an Excel 5 format into Visual Basic
Quote:
>>Not what I want. I want to >>be able to read an Excel file into an access table >>(eventually). >Download ftp://ftp.sn.no/user/balchen/vb/lotsfrmt.zip >Jens
Could you please verify this file location. I looked for it and couldn't find it. I would be very interested in it. Thank You.
Michael Park ___________________________________________________________________
?These views are my own and do not represent my company in anyway?
Sun, 26 Jul 1998 03:00:00 GMT
Jens Balchen J #4 / 7
Reading an Excel 5 format into Visual Basic
infinite reservoirs of wisdom:
Quote:
>Could you please verify this file location. I looked for it and >couldn't find it. I would be very interested in it.
*grumble* I hate UNIX. Try now.
Jens Jens -- Everything I said are the opinions of someone else. I just cut-and-pasted.
Jens Balchen jr. http://www.sn.no/~balchen
Mon, 27 Jul 1998 03:00:00 GMT
Jens Balchen J #5 / 7
Reading an Excel 5 format into Visual Basic
infinite reservoirs of wisdom:
Quote:
>Yes! is there such a thing?. Please confirm! Also does anyone know the >format used by Excel to copy to the clipboard.
don't get your hopes up - i replied to the "(or any other spreadsheet format, for that matter)" part.
-- Newbiehood is not a period of time, it's a way of life.
There is a great tool from Visual Components available. As far as I know it should be able to read Excel 5 now, too. You'll find them here: http://www.visualcomp.com/
> There is a great tool from Visual Components available. As far as I know > it should be able to read Excel 5 now, too. > You'll find them here: http://www.visualcomp.com/
The installable ISAM .DLL that comes with VB4.0 Pro will read Excel 5.0 files. I've done it and it works. There's sample code for this in the Visdata application.
Reading an Excel 5 format into Visual Basic