CSV file import problem in ms access
I have been trying to import a csv file to access and appending it to a table. It only imports some 开发者_如何学JAVAof the rows and stops arbitarily. All the lines in the csv file are in the same format. HAs anyone encounntred this problem? how can I fix it?
Make sure text data is quote-encapsulated. You may have some text fields containing commas that can throw off the record layout and hose the entire import.
精彩评论