Click here to Skip to main content
12,957,007 members (58,570 online)
Rate this:
 
Please Sign up or sign in to vote.
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 7-Feb-13 2:18am
Updated 14-Feb-13 22:26pm
v3

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

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]
  Permalink  

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

    Print Answers RSS
Top Experts
Last 24hrsThis month
OriginalGriff 6,924
CHill60 3,550
Maciej Los 3,312
ppolymorphe 2,120
Jochen Arndt 1,973


Advertise | Privacy | Mobile
Web01 | 2.8.170525.1 | Last Updated 15 Feb 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100