artful at rogers.com
artful at rogers.com
Sun Sep 10 08:37:28 CDT 2006
I'm not sure what is going wrong with your wizard, but you can always try downloading a cool program called dbScripter, which can produce insert scripts for any table. It would be a very simple edit (using a capable text editor such as NoteTab) to fix the resulting script so it works correctly. Both dbScripter and NoteTab are downloadable for free (the former is a trial, the latter has both an entirely free version and a professional version). ----- Original Message ---- From: JWColby <jwcolby at colbyconsulting.com> To: dba-sqlserver at databaseadvisors.com Sent: Saturday, September 9, 2006 5:56:41 PM Subject: [dba-SQLServer] Import wizard puts data in wrong table I am using the import wizard to pull text files into SQL Server. Even though the wizard very clearly shows that the destination is to be [dbo].[etc].[conduit] it ends up creating [dbo].[etc].[conduit005] or [dbo].[etc].[conduit006] etc. Not all of the time, the first 4 times worked perfectly but then I end up with the ...005] table. Any ideas why, ever seen this etc? Now I have a ...005] which has no field names [field1], [field2] etc. All the data is in the table etc, but no field names because the origin text files did not have the header row. Is there any (simple) way to get this appended to the correct table. This table has ~400 rows so manually building an append query manually editing (aliasing) the field names to match is not an option. John W. Colby Colby Consulting www.ColbyConsulting.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com