[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 175
  • Last Modified:

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
0
Sys_Prog
Asked:
Sys_Prog
  • 2
  • 2
  • 2
  • +2
2 Solutions
 
sirbountyCommented:
Have you tried using ADO?
Read this example: http://forums.devshed.com/archive/t-38834
0
 
sirbountyCommented:
0
 
Dang123Commented:
Sys_Prog,
    Here is a sample that may help too

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

Dang123
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

  • 2
  • 2
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now