MS Access & SAP DB

Former Member — Tue, 16 Dec 2008 07:27:31 GMT

Dear Gurus,

Any one tell me connectivity toMS Access from sap db tables.

Regards,

Senthil.

Re: MS Access & SAP DB

Former Member — Tue, 16 Dec 2008 07:34:19 GMT

convert from MS Access types to SAPDB

types: number(long) -> integer, date/time -> date, text -> varchar, memo ->

long(ascii), currency -> float. Do you see any potential problems with this?

I'm particularly nervous about the data/time fields and memo field

conversions.

I built a table using all these types. I created a csv file with all fields

enclosed in double quotes by changing all of my Access fields to type text

so Access would export the data with the double quotes. The data file looked

to me exactly as I'd want it. Despite this I could never get repmcli to get

past the first line of data as I kept getting the No data supplied error

message on one of the memo fields. Figuring I was now creating more problems

than I was solving with all these gyrations I decided to abandon repmcli and

search for another method.

I tried Microsoft DTS. It looked very promising as I was able to connect

using ODBC to both the Access table and the SAPDB table that I was to move

data from and to. When I clicked on the transfer button it all looked like

it was going to work. Hours later it was obvious it wasn't working as

nothing had changed and it should've only taken a couple of minutes. I

finally killed the DTS process. I connected to the SAPDB database using SQL

Studio (as I had many time before), but now when I tried to look at any

table using ALTER Table, SQL Studio would lock up. There had been no records

added to the SAPDB table either. I performed a complete backup of the

database as I'd read that this was necessary after using repmcli to get it

out of readonly mode, thinking maybe this was the same issue. In the end

there was nothing I could do the salvage this situation and decided to

create a new test database.

Hope it will help you.