File Import Error

Leesha
BronzeLounger
Posts: 1484
Joined: 05 Feb 2010, 22:25

File Import Error

Post by Leesha »

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
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: File Import Error

Post by HansV »

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

Leesha
BronzeLounger
Posts: 1484
Joined: 05 Feb 2010, 22:25

Re: File Import Error

Post by Leesha »

Thanks so much Hans! That did the trick!