- Home
- Premium Memberships
- Lottery Results
- Forums
- Predictions
- Lottery Post Videos
- News
- Search Drawings
- Search Lottery Post
- Lottery Systems
- Lottery Charts
- Lottery Wheels
- Worldwide Jackpots
- Quick Picks
- On This Day in History
- Blogs
- Online Games
- Premium Features
- Contact Us
- Whitelist Lottery Post
- Rules
- Lottery Book Store
- Lottery Post Gift Shop
The time is now 9:57 am
You last visited
April 26, 2024, 9:21 am
All times shown are
Eastern Time (GMT-5:00)
VB6 Prog. assistance needed...
Published:
Anyone have a good link or can describe the process of loading an array from an excel file? Do I need to use the Jet ODBC engine for this?
I'd rather not go through the cumbersome line-by-line, element-by-element process of using a .csv file to load the array... There must be some way of just grabbing the data straight from excel.
I'm going with
Dim intPick3(1 to 10376, 1 to 3) As Integer '10,376 is # of draws in Pick3
for the array of PA evening pick3 data. If I recall correctly, this should give me 3 columns * 10,376 rows (31,128 elements). "10376" will likely be replaced by a variable so I can have it read the actual number of draws for re-runs and updates.
I did work with VB6 and Access, but I can't unearth any decent info on working with excel. All I want to do is use a loop to load the array from an excel file that has the 3 digits in the first 3 columns, not reading dates and the first subscript in the array will represent the draw number.
thanks in advance for any help :-)
Comments
now all i need is to load the Pick3 history from a CSV file... Why are there no easy examples in the MSDN?
I want to read a csv file containing pick3 results into a 2 dimensional array... and there is where I am stuck...
Post a Comment
Please Log In
To use this feature you must be logged into your Lottery Post account.
Not a member yet?
If you don't yet have a Lottery Post account, it's simple and free to create one! Just tap the Register button and after a quick process you'll be part of our lottery community.
Register