SQL 2000 | CSV upload with delimiter

Posted on 2012-08-28
Last Modified: 2012-08-28
Team -

I have a csv file with ";" as delimiter & i want to upload the same onto SQL 2000 on a daily basis. I am using "Open Rowset" query to do the same. However am not sure of how to add delimiter in open rowset. any help on the same is highly appreciated.

Open Rowset Query:

'SELECT * FROM Sample.csv')
Question by:davidi1
    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    you can try to add Delimiter=; to the connection string
    LVL 13

    Accepted Solution

    Since you're doing this on a regular basis (and you're using sql 2000) you could use a dts package to make your life easier.

    Check this out and let us know if it works for you: Link
    LVL 2

    Author Comment

    I've requested that this question be deleted for the following reason:

    resolved it via DTS

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now