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?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this communityCSV 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?
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.
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.