0

I have data in excel file and I need to convert the excel file to CSV file then insert these data into sql table.

Please, how can I do it ?

Do have any solution for this problem ?

jarlh
  • 42,561
  • 8
  • 45
  • 63
sr123
  • 85
  • 1
  • 11
  • Possible duplicate of [Import CSV file into SQL Server](https://stackoverflow.com/questions/15242757/import-csv-file-into-sql-server) – PSK Feb 26 '19 at 10:54
  • One idea, save the file as a CSV using Save As in Excel. Then use SSIS, BCP or `BULK INSERT`. What have you tried so far, and where have you got stuck? This is far to broad as it is, Stack Overflow is for asking (specific) coding questions not for "how to guides". Show us what problems you're having and we can help you fix those. – Thom A Feb 26 '19 at 10:55
  • Thank you Larnu, but i sthere any possibility to get the CSV automatically no tmanually because this file needs to be generated always not one time after any modification of data(very frequent ) – sr123 Feb 26 '19 at 11:00

1 Answers1

0

You can easily do that with the SQL Spreads Excel Add-In. It allows you to use Excel to update and manage the data in any SQL Server table. You can download a trial here.

Disclaimer: I'm the founder.

JohannesGbg
  • 101
  • 1
  • 4