I am trying to import the excel data in sql tables but tables are not being retrieved but its not showing in SSMS. 2 months back when I did, it used to show but when tried to access it now its not showing.
Hi,
Thanks for posting here.
When you are transferring any data to SQL Database, the data should be structured. The process will be to convert your CSV to a table structure and then migrate it directly to SQL Azure. Actually you can write a stored procedure in SSMS to do it all in one.
Because CSV file could be tab, comma, or any other character delimited, you can do bulk insert in local DB first as described here and then sync the table to SQL Azure.
Hope this helps you.
Girish Prajwal
- Edited by Girish PrajwalMicrosoft contingent staff, Moderator Tuesday, February 24, 2015 8:31 AM
Hi,
Thanks for posting here.
When you are transferring any data to SQL Database, the data should be structured. The process will be to convert your CSV to a table structure and then migrate it directly to SQL Azure. Actually you can write a stored procedure in SSMS to do it all in one.
Because CSV file could be tab, comma, or any other character delimited, you can do bulk insert in local DB first as described here and then sync the table to SQL Azure.
Hope this helps you.
Girish Prajwal
- Edited by Girish PrajwalMicrosoft contingent staff, Moderator Tuesday, February 24, 2015 8:31 AM
Hi,
Thanks for posting here.
When you are transferring any data to SQL Database, the data should be structured. The process will be to convert your CSV to a table structure and then migrate it directly to SQL Azure. Actually you can write a stored procedure in SSMS to do it all in one.
Because CSV file could be tab, comma, or any other character delimited, you can do bulk insert in local DB first as described here and then sync the table to SQL Azure.
Hope this helps you.
Girish Prajwal
- Edited by Girish PrajwalMicrosoft contingent staff, Moderator Tuesday, February 24, 2015 8:31 AM
Hi,
Thanks for posting here.
When you are transferring any data to SQL Database, the data should be structured. The process will be to convert your CSV to a table structure and then migrate it directly to SQL Azure. Actually you can write a stored procedure in SSMS to do it all in one.
Because CSV file could be tab, comma, or any other character delimited, you can do bulk insert in local DB first as described here and then sync the table to SQL Azure.
Hope this helps you.
Girish Prajwal
- Edited by Girish PrajwalMicrosoft contingent staff, Moderator Tuesday, February 24, 2015 8:31 AM
Hello Girish,
I already have some data in the tables which I inserted through SQL Server Import and Export Wizard but now when I gave the credentials its not retrieving the tables but creating a new table as shown in the above pic.
Hi,
Sorry for the delay in response to your query.
Please try the below steps and let us know if that could help us.
1. "Could you try importing the excel data to a new table?"
2. Does this work on the on-premise SQL Server (not a new table, but appending, which you are trying to achieve)
3. run 'Process monitor' tracing while running this process and then see if there's any 'access denied' or some DLL missing error messages.
Girish Prajwal
- Edited by Girish PrajwalMicrosoft contingent staff, Moderator Thursday, February 26, 2015 8:12 AM
Hi,
Sorry for the delay in response to your query.
Please try the below steps and let us know if that could help us.
1. "Could you try importing the excel data to a new table?"
2. Does this work on the on-premise SQL Server (not a new table, but appending, which you are trying to achieve)
3. run 'Process monitor' tracing while running this process and then see if there's any 'access denied' or some DLL missing error messages.
Girish Prajwal
- Edited by Girish PrajwalMicrosoft contingent staff, Moderator Thursday, February 26, 2015 8:12 AM
Hi,
Sorry for the delay in response to your query.
Please try the below steps and let us know if that could help us.
1. "Could you try importing the excel data to a new table?"
2. Does this work on the on-premise SQL Server (not a new table, but appending, which you are trying to achieve)
3. run 'Process monitor' tracing while running this process and then see if there's any 'access denied' or some DLL missing error messages.
Girish Prajwal
- Edited by Girish PrajwalMicrosoft contingent staff, Moderator Thursday, February 26, 2015 8:12 AM
Hi,
Sorry for the delay in response to your query.
Please try the below steps and let us know if that could help us.
1. "Could you try importing the excel data to a new table?"
2. Does this work on the on-premise SQL Server (not a new table, but appending, which you are trying to achieve)
3. run 'Process monitor' tracing while running this process and then see if there's any 'access denied' or some DLL missing error messages.
Girish Prajwal
- Edited by Girish PrajwalMicrosoft contingent staff, Moderator Thursday, February 26, 2015 8:12 AM
- Marked as answer by Girish PrajwalMicrosoft contingent staff, Moderator 19 hours 8 minutes ago
Hi,
Sorry for the delay in response to your query.
Please try the below steps and let us know if that could help us.
1. "Could you try importing the excel data to a new table?"
2. Does this work on the on-premise SQL Server (not a new table, but appending, which you are trying to achieve)
3. run 'Process monitor' tracing while running this process and then see if there's any 'access denied' or some DLL missing error messages.
Girish Prajwal
- Edited by Girish PrajwalMicrosoft contingent staff, Moderator Thursday, February 26, 2015 8:12 AM
- Marked as answer by Girish PrajwalMicrosoft contingent staff, Moderator Wednesday, March 11, 2015 11:57 AM
Hi,
Sorry for the delay in response to your query.
Please try the below steps and let us know if that could help us.
1. "Could you try importing the excel data to a new table?"
2. Does this work on the on-premise SQL Server (not a new table, but appending, which you are trying to achieve)
3. run 'Process monitor' tracing while running this process and then see if there's any 'access denied' or some DLL missing error messages.
Girish Prajwal
- Edited by Girish PrajwalMicrosoft contingent staff, Moderator Thursday, February 26, 2015 8:12 AM
- Marked as answer by Girish PrajwalMicrosoft contingent staff, Moderator Wednesday, March 11, 2015 11:57 AM
Hi,
Sorry for the delay in response to your query.
Please try the below steps and let us know if that could help us.
1. "Could you try importing the excel data to a new table?"
2. Does this work on the on-premise SQL Server (not a new table, but appending, which you are trying to achieve)
3. run 'Process monitor' tracing while running this process and then see if there's any 'access denied' or some DLL missing error messages.
Girish Prajwal
- Edited by Girish PrajwalMicrosoft contingent staff, Moderator Thursday, February 26, 2015 8:12 AM
- Marked as answer by Girish PrajwalMicrosoft contingent staff, Moderator Wednesday, March 11, 2015 11:57 AM
Hi,
Sorry for the delay in response to your query.
Please try the below steps and let us know if that could help us.
1. "Could you try importing the excel data to a new table?"
2. Does this work on the on-premise SQL Server (not a new table, but appending, which you are trying to achieve)
3. run 'Process monitor' tracing while running this process and then see if there's any 'access denied' or some DLL missing error messages.
Girish Prajwal
- Edited by Girish PrajwalMicrosoft contingent staff, Moderator Thursday, February 26, 2015 8:12 AM
- Marked as answer by Girish PrajwalMicrosoft contingent staff, Moderator Wednesday, March 11, 2015 11:57 AM
- Unmarked as answer by Sharathm1 59 minutes ago
Hi,
Sorry for the delay in response to your query.
Please try the below steps and let us know if that could help us.
1. "Could you try importing the excel data to a new table?"
2. Does this work on the on-premise SQL Server (not a new table, but appending, which you are trying to achieve)
3. run 'Process monitor' tracing while running this process and then see if there's any 'access denied' or some DLL missing error messages.
Girish Prajwal
- Edited by Girish PrajwalMicrosoft contingent staff, Moderator Thursday, February 26, 2015 8:12 AM
- Marked as answer by Girish PrajwalMicrosoft contingent staff, Moderator Wednesday, March 11, 2015 11:57 AM
- Unmarked as answer by Sharathm1 1 hour 8 minutes ago
Hi,
Sorry for the delay in response to your query.
Please try the below steps and let us know if that could help us.
1. "Could you try importing the excel data to a new table?"
2. Does this work on the on-premise SQL Server (not a new table, but appending, which you are trying to achieve)
3. run 'Process monitor' tracing while running this process and then see if there's any 'access denied' or some DLL missing error messages.
Girish Prajwal
- Edited by Girish PrajwalMicrosoft contingent staff, Moderator Thursday, February 26, 2015 8:12 AM
- Marked as answer by Girish PrajwalMicrosoft contingent staff, Moderator Wednesday, March 11, 2015 11:57 AM
- Unmarked as answer by Sharathm1 Tuesday, March 24, 2015 6:07 AM
Hi,
Sorry for the delay in response to your query.
Please try the below steps and let us know if that could help us.
1. "Could you try importing the excel data to a new table?"
2. Does this work on the on-premise SQL Server (not a new table, but appending, which you are trying to achieve)
3. run 'Process monitor' tracing while running this process and then see if there's any 'access denied' or some DLL missing error messages.
Girish Prajwal
- Edited by Girish PrajwalMicrosoft contingent staff, Moderator Thursday, February 26, 2015 8:12 AM
- Marked as answer by Girish PrajwalMicrosoft contingent staff, Moderator Wednesday, March 11, 2015 11:57 AM
- Unmarked as answer by Sharathm1 Tuesday, March 24, 2015 6:07 AM
Hi,
Sorry for the delay in response to your query.
Please try the below steps and let us know if that could help us.
1. "Could you try importing the excel data to a new table?"
2. Does this work on the on-premise SQL Server (not a new table, but appending, which you are trying to achieve)
3. run 'Process monitor' tracing while running this process and then see if there's any 'access denied' or some DLL missing error messages.
Girish Prajwal
- Edited by Girish PrajwalMicrosoft contingent staff, Moderator Thursday, February 26, 2015 8:12 AM
- Marked as answer by Girish PrajwalMicrosoft contingent staff, Moderator Wednesday, March 11, 2015 11:57 AM
- Unmarked as answer by Sharathm1 Tuesday, March 24, 2015 6:07 AM
Hello Girish,
Sorry for the delay,
I tried the same procedure on-premise sql server with the same database its not showing the existing tables so that i select the table and insert the data but rather its showing the same thing which is shown in the above posted image. Its creating dbo.Sheet1 table in the database which i selected and data is inserted.
The problem is existing tables are not being shown