Hi,
I have a group of CSV files that the user imports every month without issue. This month they are getting an error that I can't get past. I've even tried copying the information into a new spreadsheet and saving as a CSV file but that doesn't work. I'm attaching a word file with the printscreens of the errors and the spreadsheet being imported.
Thanks,
Leesha
File Import Error
-
- BronzeLounger
- Posts: 1492
- Joined: 05 Feb 2010, 22:25
File Import Error
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78625
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: File Import Error
The problem is caused by the dots in the file name. If you remove them, or replace them with (for example) underscores to TTSMDailyNetSales 01_12_2021.csv, Access will be able to import the file.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1492
- Joined: 05 Feb 2010, 22:25
Re: File Import Error
Thanks so much Hans! That did the trick!