Click here to Skip to main content
15,942,770 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
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 how i do in updated data to get...??(Using SSIS Or Any Other)

if any body have an example or demo then i request to u pls send me as soon as possible...
If u have any idea then pls send me ur answer in My emailId..

My EmailId Is email

Thank You,

Email removed.
Updated 14-Feb-13 22:26pm

1 solution

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 result:
001	Stars&StripesForever	yes	2005-05-02 11:59:00.001
002	AintNoWomanLiketheOneIGot	yes	2005-12-14 11:59:02.110
003	100101011100111100000011	no	2013-02-07 07:77:59.077 

In SQL2005 Studio Management application, create a new .sql "query" by clicking on "Create New Query" button

Copy this code:
USE [cpqaAnswer]


CREATE TABLE [cpqaAnswer].[cpqa].[tblExcelTdData](

BULK INSERT [cpqaAnswer].[cpqa].[tblExcelTdDate] FROM 'C:\users\pn\datafile(td).txt'

Paste it in the editor, then type in a new SELECT clause to see the tabled data:
SELECT * FROM [cpqaAnswer].[cpqa].[tblExcelTdData]
Share this answer

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

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900