Copy data from MS Access to SQL Server
Copy data from MS Access to SQL Server
Is there a way to copy for example one column from MS Access to SQL Server or just a part of the column? I need to copy some rows of one column to SQL Server table just a way I would do this in the MS Excel. There is a great tool for manipulating data for Oracle, named PL/SQL Developer but I haven't found something similar for SQL Server.
@Gustav I asked because I don't know the way so your answer doesn't help. Could be or could not to be. What is that answer? I asked for the way and mentioned that Oracle has similar tool which is capable of doing this.
– dragy
Aug 26 at 12:07
Sorry, it was a hint only that came to my mind. Your question is per definition OT here, as SO is all about coding, not tools, neither superuser tasks.
– Gustav
Aug 26 at 16:43
Sorry, when I saw -1 I really get angry. I clearly asked for a way to copy whole or a part of the MS Excel column and paste it to SQL Server table column. I don't know why -1. How am I supposed to make a question?
– dragy
Aug 27 at 18:52
Can't tell who the downvoter is, but - again - SO is for coding questions, not questions about tools or software. There are other Stack fora for these.
– Gustav
Aug 27 at 20:05
1 Answer
1
Using ETL tools you can achieve your result. If you need opensource ETL tool then you can go ahead with Pentaho PDI. It's free.
By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.
That tool could be Microsoft Access or SQL Server Management Studio.
– Gustav
Aug 26 at 8:41