Exporting to Excel Versions

[bobsmallwood]

Is there an update that allows Paradox to export to a late version of an Excel format?

 

[TonyMcGuire]

What version are you looking for, exactly?

What version of Paradox do you have?

Have you checked out Vladimir Menkin's Excel library?

Tony McGuire

http://www.thedbcommunity.com

"It's not about having enough time. It's about priorities.

 

[bobsmallwood]

I have Paradox 9 and use Excel 2002. I have some Pdox queries that produce an Excel output but only in 5/95 format. Then I have to add a step to open that file and save as 2002 so I can then use them in mail merges in MS Word.

How would I find Vladimir Menkin's Excel library?

thanks

 

[TonyMcGuire]

I just searched on Google, "Vladimir Menkin Excel", and got a bunch of hits.

One of them was

http://www.tek-tips.com/viewthread.cfm?qid=895937&page=10

Tony McGuire

http://www.thedbcommunity.com

"It's not about having enough time. It's about priorities.

 

[SonOfTed]

Since Excel is a Microsoft application and Paradox is part of Word Perfect there are sometimes incompatibilities between the two. There are even problems occasionally between Paradox and Quattro Pro and they're part of the same software package!

I sometimes use a two-step process when importing or exporting between Paradox and Excel because it’s safer and more reliable:

Importing:

1. Create a .TXT or .CSV delimited file of data.

2. Import the file into a blank Paradox table. If the table already contains data I want to keep I simply choose the "Append" option to add the records to the table rather than replacing what is already there.

3. Be CAREFUL when appending data to a table that already has rows, particularly if it has fields flagged as KEYS.

Exporting:

1. Use the "File", "Export" commands in Paradox to export FROM a Paradox table TO a .TXT/.CSV output file. The output file should be delimited by quotes, with fields separated by commas.

2. Next open up a blank Excel spreadsheet and choose "File", then "Open", specifying the disk file you created in step 1 above. This two-step process allows the Excel application (whichever version you're using) to examine the data and produce a wizard that guides you through the import process.

Other notes:

1. On many occasions I import data FROM Excel into Paradox tables so that I can produce reports with it.

2. I used to simply click the "File" and "Import" options to import the data directly from the spreadsheet. When doing this some of my fields (particularly DATE fields) never did not convert properly.

3. Creating a TXT/CSV file with quotes around the text and commas separating all fields has given me much greater success.

 

[Rickinrsm]

I use this quite reliably.

I have found that Excel doesn't care about versions with this.

If Not exportSpreadsheet("CBAllLink.db","D:\\FLW\\Reports\\CBAllLink.xls", True)
then
errorShow()
endIf

Never fails me!

Hope it helps.

Rick