Import from Excel .xls problem

#21

If it gave you that error AND imported what looked like the correct data,
then I would guess that whoever filled out the spreadsheet was copying and
pasting and there's a tab or hard return in front of that H. (Or something
along those lines.)

My only other comment, though it isn't really in reply to this, is that Bertil's
bug list has the exact error message the OP was getting, so I would focus
on that...

FWIW,

Liz

"Jim Moseley" <jmose (AT) mapson (DOT) attglobal.net> wrote:

Quote:

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.

#22

You don't happen to have the Excel file open on your computer while you're
trying to import it, do you?

Liz

"Toby Sleigh" <toby.sleigh (AT) gmail (DOT) com> wrote:

Quote:

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?

#23

"Liz McGuire" <liz (AT) paradoxcommunity (DOT) com> wrote

Quote:

You don't happen to have the Excel file open on your computer while you're
trying to import it, do you?

Liz

No.

#24

Quote:

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

I tried exactly the same and it did NOT work!

I get an error "Could not read from file"

I tried another Excel file and got the same - I thought I had been using
this w/o problem before but maybe my memory is wrong. I will check some
more.

Anders

#25

On 5 mar, 09:29, "Anders" <and... (AT) jREMOVEjonssondata (DOT) se> wrote:

Quote:

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

I tried exactly the same and it did NOT work!

I get an error "Could not read from file"

I tried another Excel file and got the same - I thought I had been using
this w/o problem before but maybe my memory is wrong. I will check some
more.

Anders- Ocultar texto de la cita -

- Mostrar texto de la cita -

HI, sorry by my english.

i had the same problem but i repair wordperfect office 11 and the
problem was missing.

#26

<COTAINA (AT) terra (DOT) es> wrote

Quote:

- Mostrar texto de la cita -

HI, sorry by my english.

i had the same problem but i repair wordperfect office 11 and the
problem was missing.

Don't worry about your English, your suggestion worked for me.

Many thanks

Toby

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Import from Excel .xls problem

comp.databases.paradox comp.databases.paradox

Re: Import from Excel .xls problem - 03-04-2009 , 04:14 PM

Re: Import from Excel .xls problem - 03-04-2009 , 04:16 PM

Re: Import from Excel .xls problem - 03-05-2009 , 01:26 AM

Re: Import from Excel .xls problem - 03-05-2009 , 02:29 AM

Re: Import from Excel .xls problem - 03-11-2009 , 04:14 AM

Re: Import from Excel .xls problem - 03-23-2009 , 01:24 PM