REading Excel

Hi have some records in Excel

I need to read them in VB

Whats the best VB control to store/process them

How to read them all at a time

Amit
LVL 10
Sys_ProgAsked:
Who is Participating?
 
sirbountyCommented:
0
 
sirbountyCommented:
Have you tried using ADO?
Read this example: http://forums.devshed.com/archive/t-38834
0
 
Dang123Commented:
Sys_Prog,
    Here is a sample that may help too

http://www.vb-helper.com/howto_excel_to_access.html

Dang123
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Sys_ProgAuthor Commented:
I know about ADO

BUt I do not want to read it cell by cell


I want that the complete sheet is read at once into some structure [to reduce I/O cycles] and then process one cell at a time from that structurw

Amt
0
 
4ceReconSniperCommented:
you convert the excel file into a database then the rest is easy
0
 
4ceReconSniperCommented:
that is what i do
0
 
bruintjeCommented:
why don't you use the sample from sirbounty with ADO? you read it in a recordset in one go and work with the recordset throughout the code
0
 
Sys_ProgAuthor Commented:
Sorry for the dealy

I really could not visit the site for quite soem period

My extreme apologies for the same

Amit

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.