Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Tables

Status
Not open for further replies.
SQLnewcommer

SQLnewcommer

Technical User
Oct 7, 2005
15
0
0
US
Hello,
I need to read a table from a file(maybe in Excel) and display it in my VB application. I need to be able to read the values in the table too during runtime. What would be the best way to do this?
 
Sort by date Sort by votes
Generically speaking, you should use ADO to connect to the file and pull the data. If you go to , you will get examples of connection strings for excel, text, and many other data files.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Igawa29
  • Locked
  • Question
Export SQL Database Tables to Excel (User Destination)
Replies
3
Views
49
Igawa29
Igawa29
gpalmer711
  • Locked
  • Question
Word Automation - Multiple Tables
Replies
3
Views
50
SkipVought
S
rony01
  • Locked
  • Question
update columns between two tables
Replies
1
Views
36
Andrzejek
Andrzejek
Ken01
  • Locked
  • Question
Updating MS Access tables from Visual Basic 2008
Replies
3
Views
43
Ken01
Ken01
Skittle
  • Locked
  • Question
DataGrid - Update Tow Tables 1
Replies
4
Views
21
MajP
MajP

Part and Inventory Search

Sponsor

Back
Top