help - Need to export ADO recordset 
Author Message
 help - Need to export ADO recordset

I need to save my ADO recordset to a file that can be "automatically"
opened in Lotus Approach.  Using the ADO GetString method, I can easily
output my ADO recordset into a delimited ascii file.

I can open the ascii file in Lotus 123 as follows:
  'launch Lotus 123 and pass it the ascii text filename
  dblMyAppID = Shell("c:\lotus\123\123w.exe c:\data.txt", 1)
  AppActivate dblMyAppID

I can do the same with Lotus Approach and a .dbf file:
  'launch Lotus Approach and pass it the dbf filename
  dblMyAppID = Shell("c:\lotus\approach\approach.exe c:\data.dbf", 1)
  AppActivate dblMyAppID

If I pass the .txt file to Approach, the import wizard starts,
prompting the user to make decisions.  My superviser wants this step
completely automated.  I need a means of outputting my ADO recordset
into a DBF file, OR a means of translating the ascii to DBF format.

This is what I've tried, (for several hours):
1) I found a dll at www.activex.com that outputs an ADO recordset to
DBF format.  Takes about 2 minutes to output 4500 records.  There must
be a quicker solution.

2) I found several references to the DBF/xbase file structure.  I guess
that I can iterate through my recordset and create the DBF file
myself???  I don't know if this is practical.  Honestly, it seems a
little over my head.  Maybe it's easier than I realize.

3) If you haven't noticed, this is a Lotus shop.  All users have Lotus
123.  I've just started to play with OLE automation, thinking that I
can quietly open the file in 123 and perform a "save as" to save the
file in DBF format.

4) I've seen some examples that show DAO or ADO w/Jet 4.0 Provider
opening a Jet "friendly" file and saving into another Jet "friendly"
file format.  (FYI, Robert Smith has some great info on this at
http://www.***.com/ )  This doesn't work for me
because the source is not Jet "friendly", it is IBM DB2 UDB v5.2.  If I
could use the ADO Jet 4.0 Provider to open the ascii file, I think I
would have a solution.  I don't think this is possible.

All suggestions will be most appreciated.

Thanks,
Joe

Sent via Deja.com http://www.***.com/
Before you buy.



Sat, 13 Apr 2002 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Export ADO recordset via ODBC (to ADO monsters)

2. Need help with ADO recordset sorting issue

3. Need help to read comma delimited file to ADO recordset

4. Need Help Reporting on Multiple ADO (Disconnected) Recordsets

5. ADO Recordset, SQL7.0 need your help?

6. Help with Access ADO recordset needed

7. ADO Command to RecordSet Help Needed

8. Need help: ADO recordset's recordcount work unproperly with a datagrid control

9. Need help please (XML and ADO Recordset)

10. Exporting an ADO recordset to Excel

11. Can not export ADO recordset to Excel

12. How to export ado recordset to excel spreadsheet ?


 
Powered by phpBB® Forum Software