Discussion on:
Message 6 of 8
0
Votes
RE: Avoid import glitches when bringing Excel data into Access
I use Excel's TRIM function to remove extra spaces and the Text to Columns to split data eg into FirstName LastName. I also find that checking date fields in Excel gives a much better result after import.
Posted by Answers
30th Dec 2009
