July 28, 2008 at 7:38 am
I have a Data Warehouse im building up, but the Excel file im trying to import wont because, the data in one of my coloumns is to large even if i put it to varchar size 8000, i think its because there are spaces in sum of my cells, but i cannot go through about 400 000 cells to find them, so i tried using query builder in my import through Enterprize Manager using the Replace statement but it keeps returning the error 'Undefined Function 'REPLACE' in Expression' Im really struggling with this please can sumone help
July 28, 2008 at 7:45 am
If you are really in SQL Server 2005 then you could use the varchar(max) data type.
Could you explain how you are doing the import (SSIS, DTS, Linked Server, OpenQuery)?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply