Get Data From CSV to MS SQL DB - Microsoft SQL Server

Hi, i have been trying to find information about this problem to no avail,:

I have a csv file already created which i would like to insert into my database line by line.

Would it be possible for someone to show me an example of how to change the following so i can insert it into my database..???

~Many thanks for your help i am soooo stuck with this.. i am learning vb.net and sql and finding it really hard to get any real examples to help me learn.

The CSV is as follows there are

filename,filesize,modifieddate,fileversion,package ditem

Filename1,3061,17/01/2006 09:57:49,,
Filename2,157696,25/01/2006 07:57:02,,
Filename3,206,25/01/2006 14:11:17,,
Filename4,244,25/01/2006 08:27:39,,

the table is as follows:

CI_ID,BuildID,filename,filesize,modifieddate,filev ersion,packageditem

The CI_ID is the identity and the BuildId is a sep Parameter from a combobox selected value.

If anyone can help me i would be most grateful

Lost :eek:

Feb 1 '06 #1

Subscribe Post Reply

3330

Brain-Chemical

no takers????

I could do with the help on this one.... :confused:

Feb 6 '06 #2

getsaby

Just google " SQL manager 2005 for SQL Server"

Its a tool which can load data from various file format in to ur database.

Aug 27 '06 #3

Similar topics

Exporting Data Set to Excel

by: Chris | last post by:

Could someone please provide me an effective means of exporting data from a data set (or data grid) to Excel?

.NET Framework

Recommended data access model

by: Tony Lee | last post by:

Some time a ago, on this newsgroup the following comments were made in recommending good references for Access (2003) >I used to recommend Dr. Rick Dobson's, "Programming Access <version>" for...

Microsoft Access / VBA

inserting data into SQL Database

by: djozy | last post by:

Please, I want to insert data into SQL Server database. I know for this commmand: SqlCommand myCommand= new SqlCommand("INSERT INTO table (Column1, Column2) " + "Values ('string', 1)",...

C# / C Sharp

System.Data.OleDb.OleDbException: Unspecified error

by: T8 | last post by:

I have a asp.net (framework 1.1) site interfacing against SQL 2000. It runs like a charm 99% of the time but once in a while I get the following "unspecified error". Sometimes it would resolve by...

ASP.NET

An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in sy

by: NicK chlam via DotNetMonster.com | last post by:

this is the error i get System.Data.OleDb.OleDbException: Syntax error in INSERT INTO statement. at System.Data.Common.DbDataAdapter.Update(DataRow dataRows, DataTableMapping tableMapping) at...

ASP.NET

Data Binding Question

by: bbernieb | last post by:

Hi, All, Is it possible to access a variable inside of a data binding, without the variable being out of scope? (Note: On the DataBinder line, I get an error message that says "Name 'i' is...

ASP.NET

Can I get the data using sql command???

by: Gene | last post by:

What can I do if I want to get the result using the sql command? for example, the select command is "select Name from Employee where StaffID=10" How to get the "Name"??? dim Name as string and...

Visual Basic .NET

sqladapter caching data?

by: DC Gringo | last post by:

I am having a problem reading a simple update to the database. Basically I'm testing a small change to the pubs database -- changing the price of the Busy Executive's Database Guide from 19.99 to...

Visual Basic .NET

How to get the data from an ObjectDataSource in a custom control

by: Rolf Welskes | last post by:

Hello, I have an ObjectDataSource which has as business-object a simple array of strings. No problem. I have an own (custom) control to which I give the DataSourceId and in the custom-control...

ASP.NET

Computer Data Recovery

by: Winder | last post by:

Computer Data Recovery Help 24/7 Data recovering tools and services is our focus. We will recover your data in a cost effective and efficient manner. We recover all operating systems and media....

ASP.NET

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General