You are not logged in.

Import via .xls (ODBC) - what is my failure?

Dear visitor, welcome to Palo Community Forum. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

CorConDisaster

Intermediate

  • "CorConDisaster" started this thread

Posts: 4

Date of registration: Jul 30th 2011

  • Send private message

1

Saturday, July 30th 2011, 4:50pm

Import via .xls (ODBC) - what is my failure?

Hi,

how do I import data from.xls?

I tried to do that and I
get a failure: Not able to read from data base Error 42S02 Microsoft ODBC Excel
driver. The Jet database module wasn’t able to find the object “Tabelle1”. Does
the object exist? Did you enter the right name?

The Error:

http://img4web.com/view/9UK53W


The excel file where I run
Palo:

http://img4web.com/view/GCT1RD


The excel file where I try
to import from:

http://img4web.com/view/R45ZJA

I already set the import
file as a new data source:

http://img4web.com/view/XY118N

The excel file where I type
in the PALO.SETDATA code:

http://img4web.com/view/ULWY3J

The Sql code from the data
assistant:

http://img4web.com/view/V5ZAX

I saved all excel files in
a new folder inside the database I am operating in. However no sheet or cell
refers to the Excel file with the Sql code... I don't know if if have to type
in the PALO.SETDATA in a particular cell. Can anybody help me with the
failure?

axi

Sage

Posts: 661

Date of registration: Mar 5th 2009

Location: Germany / Bargteheide

Occupation: BI

  • Send private message

2

Sunday, July 31st 2011, 3:57pm

I have never tried it like this ...

When I try it does not work: architecture mismatch on my system (Win7 64Bit, XLS-ODBC 32 Bit)

What works (and I _always_ do this):
import a text-file

you can save your import-data (from Excel) as text or csv - then the import will work

CorConDisaster

Intermediate

  • "CorConDisaster" started this thread

Posts: 4

Date of registration: Jul 30th 2011

  • Send private message

3

Sunday, July 31st 2011, 6:29pm

Ah ok,

thank you for the response.
We have the same assumtion regarding the mismatch. Maybe we try it on a XP platform later this week and post if we are successful.
So far we imported via .csv.

If anyone knows the solution how to import the xls directly on Win7 - please let us know.

regards

1 user apart from you is browsing this thread:

1 guests

Similar threads

Rate this thread