However I constantly get an error "Unable to get table field descriptions"


var
dt DataTransfer
endvar

dt.setSource("C:\\SSin\\Feb09.xls")
dt.setDest ("C:\\SSin\\Feb09.db")
dt.setDestFieldNamesFromFirst(True)
dt.setProblems ( True )
dt.getSourceRange()
dt.transferData ( )

nor does
importSpreadSheet("C:\\SSin\\Feb09.xls","C:\\SSin\\Feb09.db", "A1", "L300",

false)
work.

I would be really grateful for any ideas.

Excel 97 workbook,
Paradox 11 ( 11.0.0.300)
Win XP Prof sp3

1. Are you sure Excel hasn't conveniently saved the file as something
newer
that Excel 5.0 without telling?

2. Are you sure the column headers in Excel are valid Paradox field names?

NOTE: Check bug PX0576 in Bertil's website:
http://hem.bredband.net/bertilisberg/
(under current bugs). Is your spreadsheet read-only? Anywho, there are
a lot of bugs listed there, so just search the page for "spreadsheet" and
read them until you find a solution (or that there isn't a solution).

I believe Vladimir has a free library for dealing with Excel files:
http://vmsoft.org/

Liz


"Toby Sleigh" <toby.sleigh at (no spam) gmail.com> wrote:

However I constantly get an error "Unable to get table field descriptions"


var
dt DataTransfer
endvar

dt.setSource("C:\\SSin\\Feb09.xls")
dt.setDest ("C:\\SSin\\Feb09.db")
dt.setDestFieldNamesFromFirst(True)
dt.setProblems ( True )
dt.getSourceRange()
dt.transferData ( )

nor does
importSpreadSheet("C:\\SSin\\Feb09.xls","C:\\SSin\\Feb09.db", "A1",
"L300",

false)
work.

I would be really grateful for any ideas.

Excel 97 workbook,
Paradox 11 ( 11.0.0.300)
Win XP Prof sp3

1. Are you sure Excel hasn't conveniently saved the file as something
newer
that Excel 5.0 without telling?

2. Are you sure the column headers in Excel are valid Paradox field names?

NOTE: Check bug PX0576 in Bertil's website:
http://hem.bredband.net/bertilisberg/
(under current bugs). Is your spreadsheet read-only? Anywho, there are
a lot of bugs listed there, so just search the page for "spreadsheet" and
read them until you find a solution (or that there isn't a solution).

I believe Vladimir has a free library for dealing with Excel files:
http://vmsoft.org/

Liz

Hi Liz

2. Are you sure the column headers in Excel are valid Paradox field
names?

Hate to repeat something, but the message you get indicates something
wrong when pdx attempts to identify how to format the fields. Now that
could be not recognizing the data, or simply not being able to name the
field (altho I thought it would default to something generic). YOu never
responded to Liz's question on field names.

2. Are you sure the column headers in Excel are valid Paradox field
names?

Once we see valid names are being used, the next ? would be - is the data
consistent across the board? I do believe that pdox may operate a lot
like excel and establish the "type" of each field by the contents of the
first row's cells. You may have to ensure that the first row in your .xls
contains representative data in each col so pdox has something to work
with from the start.

ok -

Job Number
Part Num
Model
QTY
Price
Availability
Date Ord
Ord by
Description
Our Ref
Bonded
ESCODid

Are you importing to a NEW table each time, or an existing table?

Tony,

Are you importing to a NEW table each time, or an existing table?

I think Tony's on to something. Does this table already exist? If so,
try
a new table like 'Feb09Input.db' or so & see if it still squawks.

dt.setDest ("C:\\SSin\\Feb09Input.db")

HTH,
Jim Moseley

Hi
I'm trying to import a very simple ( 12 columns, no fancy formatting,
originally generated by export from Paradox ) .xls into a Paradox table.
However I constantly get an error "Unable to get table field descriptions"

I've found various references to this problem , for example this
http://tinyurl.com/cs8vkv says it should work if all refs to aliases are
removed.
I've reduced what I am trying to the bare minimum, based on that thread,
but still get the error.


var
dt DataTransfer
endvar

dt.setSource("C:\\SSin\\Feb09.xls")
dt.setDest ("C:\\SSin\\Feb09.db")
dt.setDestFieldNamesFromFirst(True)
dt.setProblems ( True )
dt.getSourceRange()
dt.transferData ( )

nor does
importSpreadSheet("C:\\SSin\\Feb09.xls","C:\\SSin\\Feb09.db", "A1",
"L300", false)
work.

I would be really grateful for any ideas.

Excel 97 workbook,
Paradox 11 ( 11.0.0.300)
Win XP Prof sp3

thanks
Toby
First off, thanks to everyone who tried to help.

I finally had the idea to try the Excel import on another PC. It all works

as expected. hooraay.

But what on earth on my PC can be causing this problem?

Toby,

Trying your code with the attached spreadsheet & table worked, but I got
errors. For every column in the first record, I got 'Invalid Character.:
"H"EWLETT PACKARD OFFI' etc. It imported the data fine though.

One thing I noticed is that it always deletes the target table and
recreates
it based on the import. So, does your initial error point to the table
being
in use somewhere?

BTW, here's the exact code I used (with everything in C:\Temp instead):

method run(var eventInfo Event)
var dt DataTransfer endvar
try
dt.setSource("C:\\temp\\Feb09.xls")
dt.setDest ("C:\\temp\\Feb09Input2.db")
dt.setDestFieldNamesFromFirst(True)
dt.setProblems ( True )
dt.getSourceRange()
dt.transferData ( )
onFail
errorShow("1")
endTry
errorShow("2")
endMethod

HTH,
Jim Moseley

"Anders" <anders at (no spam) jREMOVEjonssondata.se> wrote in message
news:49aea4f0 at (no spam) pnews.thedbcommunity.com...
Toby,

I haven't followed all the post in this thread, but would it be possible
for
you to post a example of a table you wish to import so we could try to
see
if we get the same problem? If you make it with only a few test records
and
zip it, I think it would be OK to break the "no attachment" rule in the
NG.

Anders


ok , PSA.

Toby