Create a dataset or table in VB (Excel 97)

  • Thread starter Thread starter Chi Man Wong
  • Start date Start date
C

Chi Man Wong

I have a data in an Excelsheet of 10 columns by 3000 rows. I want to
put these in some kind of dataset so I can process it like this:

Column one contains dates (unique)

In sheet 2 I want to have a row of dates and now I want to look up the
data corresponding to that date in the dataset and put them in sheet
2.

Any help?
 
Chi,

What VB version are you using?

This newsgroup is for VBNet, now I have the idea that I showed you once the
newsgroups for Office.

As well did I spent time helping you with this using VBNet.

Cor
 
Cor,

yes u spend quite some time referring to this problem. Thanks for that.
I can't remember that you've given me links to the Office newsgroups.
Care to post them here? Thanks!

P.S. I think I came up with a solution even though it's not perfect from
a programmers point of view :)
 
Chi

When you don't have it

news://microsoft.public.office.developer.vba

There are a lot more.

Cor
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

basic dataset/table question 1
Regarding solving a problem in Converting Excel Data into Dataset 1
Convert XML schema to DataSet in VB Express 2008? 0
basic dataadapter/dataset question 3
An array of datasets/tables ? 4
Copy large data from one dataset to another dataset 1
Rank Dataset Contents 3
Matching data from table in VB 9

Back
Top