Export files type Random from pb3.5 to Excel

[Lance Edmonds]

Originally posted by Donald Miller:
Hey, Lance, how about something in PB instead of VB?

Sure... check out the EXCEL examples that ship with PB/CC 3.0 and PB/Win 7.0... they show you how to send data to Excel via COM. (the ealier reply did not mention COM since PowerBASIC's Windows compilers did not support COM back in 2000!)

However, that sort of functionality is is not possible from DOS... so the CSV or TSV technique is still a valid approach from DOS.



------------------
Lance
PowerBASIC Support
mailto:[email protected][email protected]</A>

[John Hackl]

Create a tab delimited file (much better than csv) called data.txt and then:

start excel data.txt

or

The excel macro language since excel5 is basic and it can be used on random files.

[Donald Miller]

The first thing that comes to mind is to create a CSF (comma separated file) and then import the file into Excel/Access, etc. Of course this would require manual work, but the 'importing' phase could be accompished with a VBA script in Excel I suppose.

Hey, Lance, how about something in PB instead of VB?

------------------
[email protected]

[Lance Edmonds]

The first thing that comes to mind is to create a CSF (comma separated file) and then import the file into Excel/Access, etc. Of course this would require manual work, but the 'importing' phase could be accompished with a VBA script in Excel I suppose.

The second idea is to write a Windows application that can read the random-access file and then use the ODBC interface to store the data in Excel's own native database files. With PB/CC you can read the files just like you can do in PB/DOS, and if you combine this with an ODBC toolkit (like SQLTools from www.perfectsync.com ) then you'll be able to perform the whole task programmatically. As a bonus, you can SHELL to a PB/CC application directly from PB/DOS and continue on when the app finishes - you'll need to be running at least Windows 95, however, as that is the 'lowest' Win32 platform PB/CC applications will work with.


------------------
Lance
PowerBASIC Support
mailto:[email protected][email protected]</A>

[MARCO RUIZ VENTURA]

How to export data from files type Random in PowerBasic to the EXCEL of Windows 98