Michael, You can use MS-SQL Server Database Import Utility and it will import all the fields for you. Its a little easier, if you save the file in excel format first.
Or are you looking to Upload the Database via web based form? Joe Eugene >-----Original Message----- >From: Michael Dinowitz [mailto:[EMAIL PROTECTED] >Sent: Sunday, November 09, 2003 10:22 PM >To: SQL >Subject: Upload help > > >I've got a tab delimited file of 20,000 rows that I need to get >into a DB. I >also need to transform some of the data as it comes in. I remember >doing this >many years ago, but the exact SQL methodology escapes me. >Does anyone have the initials or reference to what I need? Thanks > >-- >Michael Dinowitz >Finding technical solutions to the problems you didn't know you had yet > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://affiliates.macromedia.com/b.asp?id=2439&p=go/dw_aff1 Message: http://www.houseoffusion.com/lists.cfm?link=i:6:1720 Archives: http://www.houseoffusion.com/lists.cfm?link=t:6 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=<:emailid:>.<:userid:>.<:listid:>
