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 Data..so 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,
NetalPrajapati.

[Edit]
Email removed.
[/Edit]
Posted
Updated 14-Feb-13 22:26pm
v3

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	sousa@phoneydata.com	yes	2005-05-02 11:59:00.001
002	AintNoWomanLiketheOneIGot	peaches@twentysixteen.com	yes	2005-12-14 11:59:02.110
003	100101011100111100000011	ss@nautpott.com	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]
GO

CREATE SCHEMA [cpqa]

CREATE TABLE [cpqaAnswer].[cpqa].[tblExcelTdData](
 [idx][int],
    [title][nvarchar](128),
       [email][nvarchar](256)
          [status][nvarchar](16),
             [time][datetime]
             )

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