>Thanks for your response, Peter.
>
>I can build the db in SQL but I have a bunch of data that is
>currently in Excel that I need to move. I can do that through vfp
>but I am not aware of how to import that directly from Excel to SQL.
>I will keep looking but VFP does represent a path.
>
>I discovered an answer to my own question last night. I changed the
>compatability property of the db from the default of 80 to 65. There
>was obviously some character combinations within the Excel data that
>did not conform to the stricter requirements of SQL2000
>
>Many thanks
>-gn-
SQL DTS (Data Transformation Service, covered pretty well in the Books OnLine) has a built-in connection for importing Excel data. It is pretty painless if you are going straight into tables, but can handle complex transformations as well.
Dan LeClair
www.cyberwombat.comSET RANT ON - The Wombat BlogLife isn’t a morality contest and purity makes a poor shield. - J. Peter MulhernDisclaimer: The comments made here are only my OPINIONS on various aspects of VFP, SQL Server, VS.NET, systems development, or life in general, and my OPINIONS should not be construed to be the authoritative word on any subject. No warranties or degrees of veracity are expressed or implied. Void where prohibited. Side effects may included dizziness, spontaneous combustion, or unexplainable cravings for dark beer. Wash with like colors only, serve immediately for best flavor.
