Can I use Excel without Excel? 1

[tlhawkins]

Hey Guys,

I'm just starting in on a project in VB but I've never used it before so Please help me out.

I am importing a large text file and trying to sort it. I figured out how to get the whole thing into a recordset and from there I can display it but it wont let me sort it because it cannot go back to the source because it is not ADODB compatible. SO... I want to save the text data as an excel file, which I can do.

Finally what my question is:
Will I be able to save the recordset as an Excel file and sort and filter it from a computer that does not have Excel installed or does it need Excel to do these functions?

Thanks for your help.

 

[CajunCenturion]

If all that you want to do is sort the data, then using Excel may not be the best option.

You may find it easier to store the data in an Access Database. Maniuplating the Recordset with Access is straightforward, for both sorting and filtering.
Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[tlhawkins]

That sounds nice...

Can it be done without MS Access on the machine?

Thanks.

 

[CajunCenturion]

Either Excel or Access would require that the application be on the machine.

Perhaps you might look into use a Grid
Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[CCLINT]

Store the data in a MDB, which is a Jet database, the one used by Access and which is the native VB database. Then you can open, sort and filter the data using ADO or DAO with-out Access being on the machine. Only the Jet DLLs and ADO will need to be on the machine, which get distributed with the distribution package.

 

[tlhawkins]

Hey Thanks CCLINT,

That's exactly what I was looking for.

You get my vote.