I have recreated the Table in my project with all the required columns but how can I have the project download the file on the click of a Button (named CommandButton1) and then parse all of that data into the required columns in the table in my project (the data in the downloaded file is separated by a comma it seems all the way through).

Hi Matt,thanks, That works really well but, and this may show my noobiness but it says: "The name 'connectionParameters' does not exist in the current context". I have a feeling I am missing something noobie-like
–
touyetsNov 22 '12 at 9:36

To be clear, I have set up the table already, It is named x_world. It has all of the required columns, no problem. I have put it in a dataset (database1DataSet) and I have put a data grid view (DataGridView1) in a form so that i can see the data uploaded afterwards but it still says my connection parameters do not exist.
–
touyetsNov 22 '12 at 9:49

Hi again (again), I think i've sorted that issue out by changing that line to: using (SqlConnection connection = new SqlConnection(Properties.Settings.Default.x_worldConnectionString))
–
touyetsNov 22 '12 at 11:18

Hi Robbie, That absolutely sorted the first part of my issue but now to add the file to the table. I'll try the second link you sent and will let you know. Thank you so much.
–
touyetsNov 21 '12 at 22:13

If there is a question you're looking to get answered on here, please take the time to search the question archive using some keywords and "stackoverflow" in Google or whatever your search engine of choice is. We here on Stackoverflow are happy to assist with any programming question but we want to keep the archives clean of any similar or duplicated questions that may have been answered previously...
–
Robbie DeeNov 22 '12 at 0:01