SQL Server export can't use datetime for new Access 2007 ?

microsoft.public.sqlserver.tools

6 Mar 2007 4:45 PM

mibainfo

Hi,
I have problem with exporting data from SQL Server database to new access
format.
Exporting provider : Microsoft.ACE.OLEDB.12.0

Error message:
Column information for the source and destination data could not be
retrieved, or the data types of source columns were not mapped correctly to
those available on the destination provider.

followed with list of tables and all datetime field names.

For Jet.OLEDB this works for me correctly. (But all nvarchar fields are
transformed to
MEMO, regardless of length for example for length of 4 nvarchars too)

Miro