Forum Discussion
Date errors when importing csv file to Access -
Hi, tsgiannis
there are other thousands of lines in the file. I only uploaded the first 1000 because i thought it makes my case easier to understand.
Please image there are one million rows in the file and share a solution if applicable.
br, Di
Blood4Iron Hi BI
The way you are importing your .csv is the usual way...probably your problem is due to Access disregarding the comma "," as delimiter and want to match agains system delimiter....for example my system delimiter is ";"
To test it...just open your .csv with any text editor and do a replacement of comma to something else like ";" or "|" for example
Then redo the import process...select the new delimiter...it should finish just fine.
My code doesn't care about system delimiters and such ...it just accepts the delimiter you want to use and works by iterating the .csv line by line (thus its a bit slower)...on the other hand i have complete control on what to import and and how i want this imported....for example i could import numbers as text or format text to date...numbers to date...and so on.
Now for such a vast amount of lines (.csv) maybe you should consider full automation ...like pointing a directory...iterating the .csvs ...importing them....and then whatever manipulation you want....but this is beyond the scope of a simple question
JT