You are not logged in.

Import and ODBC and ACCESS

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.

franck75

Trainee

  • "franck75" started this thread

Posts: 1

Date of registration: Jul 21st 2006

  • Send private message

1

Friday, July 21st 2006, 5:37pm

Import and ODBC and ACCESS

hi !

I try to import data from access sql

--> What is the proccess to follow with ODBC ????

Thanks

Franck

h_schmieder

Professional

  • "h_schmieder" is male

Posts: 23

Date of registration: May 24th 2006

  • Send private message

2

Monday, July 24th 2006, 6:23pm

RE: Import and ODBC and ACCESS

You need first a system DNS for your access DB.
Then on the page fpr ODBC Import you select this dsn.
Put in the username and passwort for the access DB and also put in the
sql-query.

Then you can procced

ldivis

Sage

Posts: 84

Date of registration: Dec 2nd 2007

  • Send private message

3

Monday, May 19th 2008, 1:36pm

SQL import error

Hi,
I try to import data with import wizard and ODBC wih following SQL statement:
SELECT................WHERE ((Left([ITEMNUMBER],2)="PZ")) OR ((Left([ITEMNUMBER],2)="PP"));

Error message from MS ODBC driver says: Two arguments expected.
So I have changed separator from "," TO ";" but there is another problem with syntaxe,of course, because ";" ends the SQL statement. I have tested this SQL statement in Access without problem.

The question is: How to change the original statment to be used in the import wizard? I cannot find solution in this forum.
Thanks for some idea.
Lubos
Rate this thread