Showing results for 
Search instead for 
Did you mean: 

The 'actual' script in importing data from Excel

Hi there, I have an assignment where I have to create and populate a database and I did this by writting my data on an exel file .csv and now I realise that its not optimal and would like to use the insert function.

Problem is this is time consuming as the data is quite large, is there a way in which I can sidestep this to have my insert function for all my data written in without the hustle.

I'm basing myself on the fact that you can actually write in data from the 'results grid' and the script for that action will appear on a popup window for confirmation, so my question basically is; is there an equivalent for this in importing?