I tried this on the sql list, but as near as I can tell it never posted.
Is there a way to create a SQL Server database table from an .fmt file? It sure would be a lot easier than creating the tables from scratch. As a secondary note, after creating a few tables from scratch, I can't get get the bulk insert to work. It keeps telling me that "column is too long" in data file, row1, column 2. As a general note, I did not create the fmt file nor data file, they are being provided to me. In a worst case scenario, I could use cfhttp to create queries out of the files and then insert the data into the database one-by-one, but that sounds like a nightmare waiting to happen. -- Jeffry Houser | mailto:[EMAIL PROTECTED] Need a Web Developer? Contact me! AIM: Reboog711 | Fax / Phone: 203-630-9175 -- My CFMX Book: <http://www.amazon.com/exec/obidos/ASIN/0072225564/instantcoldfu-20> My Books: http://www.instantcoldfusion.com My Band: http://www.farcryfly.com ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
