Morning,



I have an Excel (.csv or .xls) file which I want to load into a VBA Array.

Any ideas?

My other option is to import the data into a table but would then need a

function to goto Row x, Column y and pull data from there. The data will

have some duplicate numbers in it (it's a transit table), I tried the

DLookup which I failed to give desired results as it was looking for an

instance of a number, not getting the number from the appropriate spot.



Any help would be appreciated.



Thanks,

Eddie.

Hi Eddie,



to save time I need more information. You have a spreadsheet with data and 

you want to pull this in to a vb app array.  Any chance you have thought of 

just linking right to the spreadsheet and pull your data from the columns and 

rows that way?



Mike

Morning Mike,



Solved it in the end, I imported my Spreadsheet into a table and used

DLookup.

I had thought of linking direct to the spreadsheet, although I wasnt sure

how, and I didn't really want to be opening spreadsheets on users systems.



Of course, if you know how to read/write a spreadsheet without being opened,

I'd love to know it (I'm a newbie), as part of this project is squirting out

Excel reports. Some are multi worksheet, which makes it tougher to fathom

out. I'm sure it's gonna hit some ADO, but I havent checked fully yet.



Thanks,

Eddie.





-----Original Message-----

From: Mike McCrossin [mailto:mike_mccrossin@h...]

Sent: Monday, August 13, 2001 8:47 AM

To: Access

Subject: [access] Re: Getting Data From Excel Spreadsheet in Array in

VBA





Hi Eddie,



to save time I need more information. You have a spreadsheet with data and

you want to pull this in to a vb app array.  Any chance you have thought of

just linking right to the spreadsheet and pull your data from the columns

and

rows that way?



Mike