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

M

mibainfo

Hi,
I have problem with exporting data from SQL Server database to new access
format.
As exporting format I try to use 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 transformed to
MEMO, regardless of length for example for length of 4 chars too)

Miro
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

export excel data to access table using ADO 0
ETL using MS Access 0
Connection string to Access 2007 0
2147467259 Unexpected Error from external database driver [Non admin user] 2
Exporting data with vba from Excel to an Access 2007 db with password 8
Access 2007 and connecting to SQL server 2008 6
OLEDB to 64bit SQL Server 4
problem writing an Excel file on server using Microsoft.ACE.OLEDB. 1

Top