Hello,
I have a LONG list of items i need to put into a database.
It is like this:
example word another example word
new entry
another entry this one is a little bit longer than the other two
etc etc
The database has two fields, id and sentence. id auto increments so i don't need to put that in
How can i easily import it? At the moment the best i've found is running a macro to replace the words with insert into `table` ('key') ('sentennce one'),('etcetc');
But it is taking forver. I've so far moved about 2 pixels down on the scroll bar, in the program I am using (textpad).
Is there any easy way to import it?
I have a LONG list of items i need to put into a database.
It is like this:
example word another example word
new entry
another entry this one is a little bit longer than the other two
etc etc
The database has two fields, id and sentence. id auto increments so i don't need to put that in
How can i easily import it? At the moment the best i've found is running a macro to replace the words with insert into `table` ('key') ('sentennce one'),('etcetc');
But it is taking forver. I've so far moved about 2 pixels down on the scroll bar, in the program I am using (textpad).
Is there any easy way to import it?