I wanted to ensure that I didn't "screw" this up - so I wanted to do a "trial" using just a small amount of data - so that I get the data format correct / procedure correct etc..
(I'm assuming that the imported data should be in the same format - field names etc..?)
I logged into my admin area - went to the Links table and did an export to see what the data looked like / what sort of format the data was in.
exported my data as listoflinks.txt (only 7 links)
could see that the data is delimted by this "|"
eg.....lsql_Links.ID|lsql_Links.Title|
in Excel - imported the data from listoflinks.txt - with a view to "adding a few records" and then I was hoping to save file as "delimited file type" - then import to my server LinksSql - build changed? (not sure) then look to see if the additional records were correct.
Excel - saving file - only see save as text file with tab / space or comma delimiter
In MySqlMan - could see import data with delimter option showing this "|"
need some help please
on importing data - does the imported data need to include the records already in the database?
or does LinksSql "add" the new imported records to the database?
Colin Thompson