October 1, 2002 at 1:10 am
Ok...ok...what is the deal with SQL Server and generating Dollar tables when I import from excel files. Does anyone know the exact set of circumstances when SQL Server (7 by the way!) decides 'oh I think I will add a dollar table'. To me it seems to be leftovers from yesterdays 'bad imports' that failed..... Does anyone have the answer?
October 1, 2002 at 2:38 am
My guess is that this has to do with how Excel names it's 'tables', SQL just use the name that Excel recommends. Naming the tables manually would solve the problem.
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
Edited by - chrhedga on 10/01/2002 02:38:10 AM
October 1, 2002 at 10:28 am
Excel defaulst to sheet$, which is a valid identifier in SQL (with brackets), so SQL creates a table and uses this name.
If you want a different name, create the table, or use DTS and change the name before creating the table.
Steve Jones
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply