Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Importing data from Access into ASE 11.9.2

4 posts in Windows NT Last posting was on 2000-05-28 21:30:58.0Z
Evan Davey Posted on 2000-05-28 07:30:01.0Z
From: "Evan Davey" <evand@alphalink.com.au>
Subject: Importing data from Access into ASE 11.9.2
Date: Sun, 28 May 2000 17:30:01 +1000
Lines: 13
Organization: Redshift Solutions
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
Message-ID: <VwnJceHy$GA.288@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: me-as-06-048.free.net.au 202.147.23.48
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2101
Article PK: 1089831

Hi,

I need to import a whole chunk of data from an access database into a Sybase
ASE 11.9.2 database.... Is there an easy way to do this?

I'm using Sybase ASE 11.9.2 on Windows 2000, want to import from an access
2000 table...

Regards,

Evan Davey


Bruno Franx Posted on 2000-05-28 10:15:03.0Z
Reply-To: "Bruno Franx" <bruno.franceschini@tin.it>
From: "Bruno Franx" <bruno.franceschini@tin.it>
References: <VwnJceHy$GA.288@forums.sybase.com>
Subject: Re: Importing data from Access into ASE 11.9.2
Date: Sun, 28 May 2000 11:15:03 +0100
Lines: 6
Organization: Bruno Franceschini
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
Message-ID: <WROvfbIy$GA.203@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: rub076.bz00.ne.interbusiness.it 194.243.180.76
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2100
Article PK: 1089824

I did it with from access via odbc into sybase
you need odbc driver for sybase
bye


Evan Davey Posted on 2000-05-28 15:28:14.0Z
From: "Evan Davey" <evand@alphalink.com.au>
References: <VwnJceHy$GA.288@forums.sybase.com> <WROvfbIy$GA.203@forums.sybase.com>
Subject: Re: Importing data from Access into ASE 11.9.2
Date: Mon, 29 May 2000 01:28:14 +1000
Lines: 17
Organization: Redshift Solutions
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
Message-ID: <XXGZspLy$GA.204@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: me-as-02-213.free.net.au 202.147.19.213
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2099
Article PK: 1089825

I tried that, and get an error:

ODBC- call failed
[INTERSOLV][ODBC SQL Server Drivers][S (#102)

Any ideas?

"Bruno Franx" <bruno.franceschini@tin.it> wrote in message
news:WROvfbIy$GA.203@forums.sybase.com...
> I did it with from access via odbc into sybase
> you need odbc driver for sybase
> bye
>
>
>


Bruno Franx Posted on 2000-05-28 21:30:58.0Z
Reply-To: "Bruno Franx" <bruno.franceschini@tin.it>
From: "Bruno Franx" <bruno.franceschini@tin.it>
References: <VwnJceHy$GA.288@forums.sybase.com> <WROvfbIy$GA.203@forums.sybase.com> <XXGZspLy$GA.204@forums.sybase.com>
Subject: Re: Importing data from Access into ASE 11.9.2
Date: Sun, 28 May 2000 22:30:58 +0100
Lines: 7
Organization: Bruno Franceschini
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
Message-ID: <ogR3NVOy$GA.279@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: rub076.bz00.ne.interbusiness.it 194.243.180.76
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2098
Article PK: 1089823

look at http://download.sybase.com/esd/odbc.html
and check your odbc version
I think you're using bad odbc version ?
bye