Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 importing from access

Author  Topic 

homerjay80
Starting Member

26 Posts

Posted - 2007-05-18 : 11:20:32
Hello,

When I'm importing an excel table to SQL2005 and go to the column mappings it defaults to ignore for columns which were valid in access. It won't let me set it back. Why is that?

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-05-18 : 11:40:42
Do you import data from excel or access?
Go to Top of Page

homerjay80
Starting Member

26 Posts

Posted - 2007-05-18 : 11:41:25
Disregard,
It was because the orginal import was partially sucessful so it accounted for the difference in column attributes.
Go to Top of Page
   

- Advertisement -