Importing a Text file to a Database

[mpayne]

Hello,

I am new to using databases with LabVIEW. I am trying to import a text file into my database, SQL express, using LabVIEW. I am currently using the database connectivity tool kit already in LabVIEW. The current problem I need help with is figuring out how to connect my text file path, called "raw data path", into the "data" input of the DB Tools Insert Data VI. This text file has all my columns and data (around 400 columns) and I don't know how to connect this path to the DB Tools Insert Data VI so that I can import each column into my SQL express database. Below is a picture of what I have so far but I do not believe this is correct. I have also tried to replace the read to text file with a read delimited spreadsheet VI. Every other part of my code besides the "raw data path" part is correct though. 

Thank you

[paul_cardinale]

You probably need something like this:

[mpayne]

I made an excel file with random numbers in two columns to try and simply it. I added the part you suggested to use but in my SQL table the two columns are just about 1000 columns of zeros in both of them. I added a zip file with the excel file, my vi, a screenshot of my SQL table, and my udl file to connect to SQL(which im pretty sure you do not need). is there a reason why columns in SQL are all zeros?