SQLTeam.com | Weblogs | Forums

Import Wizard & Table Names


#1

Hi there,

I'm importing worksheets from an Excel file using the Import Wizard and most of my table names, once imported, have single quotation marks around them and $ at the end. Does this always happen and is there a way to prevent this?

For example, in the Excel file, one of the worksheets is named 01_age_range_children_201505 but once I import it into SQL Server the table name becomes '01_age_range_children_201505$'

I know I can fix this on the Edit Mappings but there are hundreds of files so I would want to avoid this.

Thank you!


#2

'SheetName$' is the default behavior. that cannot be changed without manual work in DTS.
if you do with SSIS package this can be handled using SCRIPTs