-1
votes
1answer
134 views

SQL import data when both source and destination has data and identity column

I am using Import and export data option to import data from one database to another database. Both database have similar structure of tables. All the tables have primary key which is identity ...
0
votes
1answer
68 views

Import errors importing CSV to SQL Server table

I am using SQL Server 2014 Management Studio to import a very large .CSV file into a table. So far I have been trying to accomplish this by right-clicking on the database and selecting Import Data, ...
3
votes
0answers
62 views

Using Import Wizard with Access - No null values

I am trying to import a table from Access to SSMS using the Import Wizard but when I do the resulting table has a lot of empty strings instead of the NULL values that I am expecting. How do I make ...
0
votes
0answers
17 views

Network flow for Import Export Wizard

When I use the Import Export Wizard on my workstation to move data from ServerA to ServerB does the data flow over the network directly from ServerA to ServerB? Or does it go from ServerA to my ...
4
votes
2answers
683 views

Import Data replaces NULL with 0

I am using sql server 2008 r2 express. I am getting some problems when i use import data feature to import data from one database to another. I am using SSMS to do it. While using the wizard i choose ...