I've used a spreadsheet for data entry on a number of occasions. It is quite handy! All it requires is a string concatenate function, and a bit of cleverness. This is great for "quick-n-dirty" data entry, or for searches. The comma separated list is usually used for "SELECT * FROM TBL WHERE X IN ( ## excel text goes here ## )".
# to build a comma separated list
=CONCATENATE("'", A2, "',")
# insert new records
=CONCATENATE("INSERT INTO #t (Nbr, Code, Descr) VALUES ('", A4, "', '", B4, "', '", C4,"');")
# to build a comma separated list
=CONCATENATE("'", A2, "',")
# insert new records
=CONCATENATE("INSERT INTO #t (Nbr, Code, Descr) VALUES ('", A4, "', '", B4, "', '", C4,"');")
Comments