At 03:50 AM 11/9/2010, Luc Delcoigne wrote:
Razzak,
I have tried the ODBC migration .......however I get the message "
Cannot Attach a DATETIME column to existing Consultdate of Type DATE"...
It seems that the date and time columns in Access are really a DATETIME
field, which seems to be different from the Rbase Date And Time fields.
So the import works but all the date and time fields are left blank in
the Rbase table....
How can I solve this annoying problem ??
Luc,
When SATTACHing a server table, you can still bring in the data using
the columns with conflicting data types as "ALIAS" column names. This
approach will bring in the data as is, and let you review the actual
data, etc. Then, you can use the INSERT option to insert rows with
appropriate data into the desired table(s).
HELP SATTACH should reveal all details, including a few examples.
Very Best R:egards,
Razzak.
