Incorporate xls and xlsx files in VB 6.0

how to read xls and xlsx files in VB 6.0

Page 1 of 1

1 Replies - 5892 Views - Last Post: 10 September 2009 - 02:16 PM Rate Topic: -----

#1 snanubala  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 10-September 09

Incorporate xls and xlsx files in VB 6.0

Post icon  Posted 10 September 2009 - 02:22 AM

I am using connection string "DRIVER=MICROSOFT EXCEL DRIVER (*.XLS);MAXSCANROWS=8;MAXBUFFERSIZE=2048;FIL=EXCEL 8.0;DRIVERID=790;DBQ=Filep path and Filename". I am able to read excel files using this. I want to read the file with .xlsx format. SELECT * " & _
"FROM [DATA] " & _ "Where Len([Amount]) > 0".
I am not able to read .xlsx files. It is giving an error external table is not in format.

Please advice me,..
Thanks,

Is This A Good Question/Topic? 0
  • +

Replies To: Incorporate xls and xlsx files in VB 6.0

#2 June7  Icon User is offline

  • D.I.C Addict
  • member icon

Reputation: 104
  • View blog
  • Posts: 904
  • Joined: 09-December 08

Re: Incorporate xls and xlsx files in VB 6.0

Posted 10 September 2009 - 02:16 PM

So you tried .xlsx in place of .xls in the connection string and that failed? Maybe Excel 8.0 is wrong version number?
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1