hi Wendell, thanks for responding. I am still having the issue with a table that is linked to SQL. I found that the error is because of...

Hi Steve, Hi Lowell, Thank you for responding.

Steve, I can re-post this in the access forum, but I was not sure if this may be a permissions error...

hi everyone, I am having a very similar issue. Was there ever a resolution?

I get the same error number -2147217887 but with this error message "ODBC--call failed.". I...

i did find out one thing, the Review Data Type Mapping screen in the Import and Export Wizard of SQL Server doesn't show for MS Access to SQL Server, but...

my guess is of the almost 100 people who have looked at this post, no-one has.

have you ever migrated data from MS Access to SQL Server 2008 r2?

is this screen only for a certain input? (i.e. flat file)

Have i stated a problem that no-one has seen? does this screen (Review Data Type Mapping screen) show up for everyone else?

ok, then is it a feature that needs to be turned on?

Could the reason why I do not see the 'Review Data Type Mapping' screen because I am using SQL Server 2008 R2 Developer edition as opposed to Enterprise Edition?

has anyone ever come across this? Better still, is there another way to migrate data from MS Access to SQL server where there are options to bypass data that...