Member Avatar for saybabs

I have a csv file i am submitting to database directly. I have tried many means but still not able to bulk copy into the database table.

I have suggestions from people. All suggestions are welcome.

Edited by deceptikon because: Closed as duplicate
  • 3 Contributors
  • 2 Replies
  • 209 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by deceptikon

Recommended Answers

All 2 Replies

Member Avatar for hericles

Check out how to load a file using LOAD LOCAL INFILE command for MySql or for MSSQL the bulk insert method e.g.

BULK INSERT OrdersBulk 
    FROM 'c:\file.csv' 
    WITH 
    ( 
        FIELDTERMINATOR = ',', 
        ROWTERMINATOR = '\n' 
    )

Which database are you using and, more importantly, what error are you getting?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.