0

CSV format cannot be used for importing text files to a database unless the table for the data is already defined in the database.

is this true or false?

4
  • Please tag this question with the RDBMS that you are using. Thanks. Dec 17, 2015 at 14:37
  • In the case of an RDBMS this is certainly true. Dec 17, 2015 at 16:31
  • It won't hurt to simply try it.
    – Rick James
    Dec 18, 2015 at 5:24
  • "Is this true or false"? Neither. Cardboard boxes cannot be used to load groceries into a car unless the trunk is already open. Is this true or false?
    – mustaccio
    Jan 3, 2016 at 4:02

1 Answer 1

-1

For MS SQL Server. False: You can use the Import Data Wizard to map your columns in the CSV file to columns in the Table that the Wizard will create when you run it.

2
  • Technically the table is created before the file is imported, as would be shown in the SSIS task flow generated by the wizard. I was thinking FileTable maybe but then I guess the FileTable is the table that needs to be already defined. Really, the question sounds like it's off a quiz.
    – Avarkx
    Dec 17, 2015 at 17:04
  • The user is asking about MySQL not SQL Server
    – Erik
    Dec 17, 2015 at 18:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.