I have a gigabyte worth of CSV files that are delimited by the | symbol. The problem I have is that some of the records are posing a problem since there are double quotes contained within. The only solution I am able to find is to manually change the records, which is rather impractical for me.
Is there some way of telling Access to disregard them? Or possibly another solution?
Could you open the csv in excel, use the text to columns function, and then save it as a spreadsheet to import into Access?
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
I could, but there are a few hundred CSVs that I would prefer not to have to go through...
This link might help you to prep your files.
http://www.excelforum.com/excel-prog...ow-to-use.html
Alan
Alan
Click the * below to say thanks.
Database Principles
Pivot Table Tips
Good Excel Video Tutorials
Sumifs or SumProduct
DataPig Access Tutorials
MS Query Tutorial
Worst Pie Chart Ever?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks