I've got my sql table set up as:
[entrydate] [datetime] NULL,
[shipdate] [datetime] NULL,
when i try to import there is a conversion failure on the shipdate. so i switched the data type to a varchar 100 and it loads. What is the better data type for the shipdate column? Should i keep it at a varchar?
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.