Click here to Skip to main content
15,884,298 members
Articles / Database Development / SQL Server

import the live data in excel to sql server database

Rate me:
Please Sign up or sign in to vote.
0.00/5 (No votes)
14 Feb 2013CPOL 2.7K  
Dear Friends, I Need help to import the Live Currency Live data in Excel format(Enable Macro) to SQL server databse. I import the data in sql server database but its display only Last updates Data..so how i do in updated data to get...??(Using SSIS Or Any Other) if any body...

Alternatives

Members may post updates or alternatives to this current article in order to show different approaches or add new features.

Please Sign up or sign in to vote.
7 Feb 2013RedDk
Likely a less complicated solution exists. But not without some reading up on the subject wrt Excel ...You could however just "save" your spreadsheet as a text file with .txt extention making sure it's "td" (tab-delimited). Something like this will...

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



Comments and Discussions