Here's a quick-and-dirty tip that's saved me plenty of time.
When importing the comma-delimited text file into the import-export tool, every record must be on a separate line.
I provide an Excel spreadsheet to my clients, for them to fill in with the product inventory. Invariably, they introduce carriage returns/linefeeds into the text of the ShortDescript
ion & LongDescript
ion fields (and other fields sometimes, too!). Problem is, when I export from Excel to a text file, these spurious CR/LFs break the
1 record = 1 line in the text file rule).
So, to clean up my clients' data, I import the Excel sheet into Access to do various housekeeping. One of the handy update queries is as follows, to strip out the linefeeds (for some reason this also takes care of the carriage returns too, without having to do a replace on chr(13). For your handy referernence, here's the Access/VB expression to use in an Update query to clean up the LongDescript
ion. Just replace the "LongDescript
ion" text with the name of your field, if you want to clean up a different field.
[2]
Code:
UPDATE Products SET Products.LongDescript[b][/b][b][/b]ion = Replace([LongDescript[b][/b][b][/b]ion],Chr(10),'');
[/2]