Stack Overflow
Stack Overflow

Questions tagged [sql-import-wizard]

57 questions
13
votes
2 answers

Import data from Excel Wizard automatically detects data types

Hello I'm trying to import data from excel file (xls) to new SQL table so I use Import and Export data 32/bit to achieve that. When I load the excel file it automatically detects data types of columns. e.g. column with phone numbers is as data type…
Marek
  • 3,555
  • 17
  • 74
  • 123
5
votes
1 answer

SQL Import and Export Wizard map nvarchar(max) to its equivalent data type in csv

Using SQL Import and Export Wizard i am importing data from csv file to SQL tables, but in SQL Table is having Column data type nvarchar(max) and i have to convert my data type equivalent to nvarchar(max), i am Tried DT_STR , DT_WSTR,. and according…
Monal
  • 69
  • 1
  • 1
  • 3
4
votes
3 answers

SQL Server 2008 R2 Excel Import

I'm using SS 2008 R2 and Office 2010 on a Windows 7 64 bit. I am trying to use the import wizard to import an excel sheet into a table. I get this error: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.…
2boolORNOT2bool
  • 557
  • 3
  • 9
  • 23
3
votes
0 answers

Error while importing flat file "Microsoft.SqlServer.Prose.Import"

I am getting error while inserting flat file into SQL Server. Direct transfer from SQL Server to SQL Server is not possible. Data has to be exported and then imported. Note : Data was exported from SQL server with text qualifier "double quotes" and…
rachel
  • 225
  • 2
  • 5
  • 16
3
votes
2 answers

SQL Server Import and Export wizard

I am importing a CSV file into an existing Database and am getting a few errors Executing (Error) Messages Error 0xc02020a1: Data Flow Task 1: Data conversion failed. The data conversion for column "supervisor" returned status value 4 and…
eggwhites
  • 75
  • 3
  • 11
2
votes
0 answers

Importing Excel into SQL Server database

The SQL Data Import Wizard doesn't allow me to change the column types in the "Edit Mappings" option...so I started going down the road of "write a query" for the data transfer. I got some examples online & enabled 'ad hoc queries' on my machine. …
Prisoner ZERO
  • 13,848
  • 21
  • 92
  • 137
2
votes
1 answer

MySQL Workbench Data Import Wizard is not displaying all columns from the CSV

I'm trying to import my data from a csv to an existing table using the "Table Data Import Wizard" and when I'm in the "Configure Import Settings" it is just displaying the first 5, and I need the information of the others. Does somebody know how can…
Elizabeth S
  • 21
  • 1
  • 4
2
votes
1 answer

PostgreSQL import not working

I have been trying to import a postgres dump (with psql dbname < dump.sql and its variants, specifying hostname and username and so on), but I have been unsuccessful with it so far. I am new to Postgres, so I may have been missing the obvious here.…
Soumendra
  • 1,174
  • 1
  • 15
  • 28
2
votes
2 answers

Can I do a foreign key lookup while importing data into SQL Server 2005?

Background I have a spreadsheet of data that I'm importing into SQL Server 2005. I'm using the Import Wizard in Management Studio to do this. Problem I'm importing the data into Table A. Table A has a foreign key reference to Table B. My…
The Matt
  • 6,618
  • 7
  • 44
  • 61
1
vote
1 answer

Culture not supported in SQL Server Import and Export Wizard

I've been trying to import data from an Excel file to SQL Server DB. Strangely, I have been successful 2 times since yesterday and unsuccessful hundreds of other times. I thought playing with the connection string in SQL Server Import and Export…
Iraj
  • 319
  • 3
  • 17
1
vote
1 answer

SQL query from import wizard

I imported an Excel (.xlsx) file into a table in SQL Server using the import wizard. I want to get the query used to import so that I can store it and incorporate it in a SQL Server stored procedure. How can I get that query?
Yash
  • 319
  • 1
  • 4
  • 6
1
vote
0 answers

Unable to use SQL Server Import/Export Wizard

I am currently working in Microsoft SQL Server Management Studio, and have just downloaded the SQL Server Import/Export Wizard. All I am trying to do is import data into my SQL environment from an Excel file. Something tells me that this should not…
skrtcobain
  • 11
  • 1
1
vote
0 answers

Why am I unable to upload this dataframe into a table in MySQL Workbench?

When I try to use the data import wizard I get this error saying: "Can't analyze file. Please try to change encoding type." I saved my data frame as a csv delimited file Here is the data I wish to import into a table in MySQL…
Bradley Herro
  • 19
  • 3
1
vote
1 answer

SSIS transfer tables between sql servers - slow

I extract 5 tables from sql server A to B. Each extraction is a query that joins many tables. I usually run these extractions in sql server import wizard. I put them in SSIS (5 parallel extractions) now and I notice it's much slower (at least 50x…
YJZ
  • 3,934
  • 11
  • 43
  • 67
1
vote
1 answer

SQL Server Import Wizard - Is It Possible provide the Query Source and Filter Existing Records in Destination?

I have to import 500,000 records from a database source in another server using wizard, because import wizard uses bulk insert. I want to provide a source query with a filter to check if record exists in destination. Is it possible? What's the best…
Souza
  • 110
  • 11
1
2 3 4