Paradox to Excel

[WelshyWizard]

Hi all,

I'm looking to export records and headers from 3 seperate Paradox tables, into Excel. Easy I can hear you say?

Currently I do this useing the code below:

If Not exportSpreadsheet("ARWHParts.db","C:\\ARWHParts.xls", True)
then
errorShow()
endIf

If Not exportSpreadsheet("ARWHGdrs.db","C:\\ARWHGdrs.xls", True)
then
errorShow()
endIf

If Not exportSpreadsheet("ARWHBolts.db","C:\\ARWHBolts.xls", True)
then
errorShow()
endIf

However, what I really want is for all 3 tables to be saved on the same worksheet within the same xls file... Either underneath each other or next to each other. Hopefully at this point I can still hear someone say easy because I haven't got a clue!

Any help would be great.
If I have to settle for saving them on 3 seperate worksheets in a single xls file then I will!

Cheers.

Today is the tomorrow you worried about yesterday - and all is well.....

 

[harrymossman]

Would it be an option to use an Excel macro once they have been converted?

 

[WelshyWizard]

I did wonder that myself. I could but wanted to try and get it all neatly bundled in Paradox.

I did try and link the other way around and pull info out of Paradox 8 and into Excel 2003 but it wouldn't work. No matter what I tried!



Today is the tomorrow you worried about yesterday - and all is well.....

 

[jlockley]

identical, I take it?

 

[WelshyWizard]

The tables? No they are all different.

Today is the tomorrow you worried about yesterday - and all is well.....