how to pull data from excel sheet and display in the VB form

Hey Guys..... i'm new to VB.NET.... i would like to know how to pu

Page 1 of 1

2 Replies - 4850 Views - Last Post: 21 July 2008 - 12:57 PM Rate Topic: -----

#1 Highwayman  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 18-July 08

how to pull data from excel sheet and display in the VB form

Post icon  Posted 18 July 2008 - 07:16 AM

Hey Guys..... i'm new to VB.NET.... i would like to know how to pull data from excel sheet and display in the VB form....... i would like to know the details like connection string to use, how to write the queries to pull data from xl sheet and also the format of the columnnames (like should it be [column_name] ??)..

Thanks for your help..
Is This A Good Question/Topic? 0
  • +

Replies To: how to pull data from excel sheet and display in the VB form

#2 Jayman  Icon User is offline

  • Student of Life
  • member icon

Reputation: 418
  • View blog
  • Posts: 9,532
  • Joined: 26-December 05

Re: how to pull data from excel sheet and display in the VB form

Posted 18 July 2008 - 08:36 AM

[rules][/rules]
Was This Post Helpful? 0
  • +
  • -

#3 Highwayman  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 18-July 08

Re: how to pull data from excel sheet and display in the VB form

Posted 21 July 2008 - 12:57 PM

The error i get is "ERROR[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified ".

I have used the connection string as

'Microsoft.Jet.OLEDB.4.0',
'Data Source=C:\test\xltest.xls;Extended Properties=Excel 8.0'

Also please let me know the format for the column names in the excel sheet and the format for the sql query.

Thanks a lot...
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1