I have what is inevitably a stupid noob question, but don't know, so here goes...
How do a I take an excel spreadsheet and import it to fill the data of a sql table? I ahve the entire spreadsheet setup with column headers matching the names of the table column headers, and i just want to "pour" this spreadsheet in to the table.
Also, i need to wipe out all the data in the current table, but keep the column header names.
Any help would be appreciated- thank you.
How do a I take an excel spreadsheet and import it to fill the data of a sql table? I ahve the entire spreadsheet setup with column headers matching the names of the table column headers, and i just want to "pour" this spreadsheet in to the table.
Also, i need to wipe out all the data in the current table, but keep the column header names.
Any help would be appreciated- thank you.