A newbie trying to figure out how best to import data from MS Word into a SQL Server db. I'm also open to any other suggestions if using tables in Word isn't the greatest solution. Thanks in advance.
MS Word TableA Example:
Customer ProductNo
Johnson 5
Stevenson 10
Williams 16
MS Word TableB Example:
ProductNo ProductNotes
5 Silk scarves manufactured in China and
distributed by Xi-Ling Exports.
10 Ginzu kitchen knives. Set of 52 stainless steel
pieces.
16 Ping titanium golf clubs. 1 year warranty.
MS Word TableA Example:
Customer ProductNo
Johnson 5
Stevenson 10
Williams 16
MS Word TableB Example:
ProductNo ProductNotes
5 Silk scarves manufactured in China and
distributed by Xi-Ling Exports.
10 Ginzu kitchen knives. Set of 52 stainless steel
pieces.
16 Ping titanium golf clubs. 1 year warranty.