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!