Hi
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.
Bluesky
