Hello, I'm having a problem with importing an Excel file
with DTS. When doing this I see 2 entries for each sheet
in the Excel file but one has a $. The one with the $ has
all the fields from Excel when I preview it but the one
without the $ doesn't have the last field (going to a bit
field in SQL). When I look at the transformations for the
Source on the last field it says "ignore" and the field
isn't in the list to choose from Excel. Can anybody tell
me what's going on?
Thanks,
VanFound the problem. Instead of "1"s and "0"s in Excel, I
needed to use "True"s and "False"s for bit fields.
>--Original Message--
>Hello, I'm having a problem with importing an Excel file
>with DTS. When doing this I see 2 entries for each sheet
>in the Excel file but one has a $. The one with the $
has
>all the fields from Excel when I preview it but the one
>without the $ doesn't have the last field (going to a bit
>field in SQL). When I look at the transformations for
the
>Source on the last field it says "ignore" and the field
>isn't in the list to choose from Excel. Can anybody tell
>me what's going on?
>Thanks,
>Van
>.
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment