Forum Discussion
Solved
Where is data hidden in Excel csv file
Our vendor will send csv data files to us showing recent financial activity. They also send a pdf file the shows the actual date the funds are deposited to our bank. The dates on the csv do not alway...
csv hides nothing, actually that's a text file. Why you system give an error that could be dozens of reasons, depends on which logic it uses.
For example, in a row in first column you have date and in second cell something like 3ABCxyz where 3 says that next data shall be taken at 3 rows down. Whatever else.
I beg to differ. If I copy the contents of cell in a CSV file from one Excel spreadsheet to a new excel spreadsheet, and delete the cell contents I don't need, when I try to open the new CSV spreadsheet in our database, the db throws an error. The error lists how many instances in total, and the number by field of data that is incorrect.
I opened one of the original CSV files in Notepad and there is no data indicating row, column, field. See below.
Membernum,Ffundnumber,Fdate,Famount,Fcheck_number
33328562,1,12/07/2021,300.00,EFT
33328562,35,12/07/2021,100.00,EFT
33328562,57,12/07/2021,100.00,EFT
669,1,12/08/2021,180.00,EFT
669,278,12/08/2021,100.00,EFT
43262707,1,12/07/2021,400.00,EFT
33585272,1,12/08/2021,100.00,EFT
33261074,1,12/07/2021,175.00,EFT
33261074,278,12/07/2021,75.00,EFT
I opened one of the original CSV files in Notepad and there is no data indicating row, column, field. See below.
Membernum,Ffundnumber,Fdate,Famount,Fcheck_number
33328562,1,12/07/2021,300.00,EFT
33328562,35,12/07/2021,100.00,EFT
33328562,57,12/07/2021,100.00,EFT
669,1,12/08/2021,180.00,EFT
669,278,12/08/2021,100.00,EFT
43262707,1,12/07/2021,400.00,EFT
33585272,1,12/08/2021,100.00,EFT
33261074,1,12/07/2021,175.00,EFT
33261074,278,12/07/2021,75.00,EFT
Sorry, I didn't catch. That's your text in Notepad
and same if open in Excel
Another story Excel could change formats, but you may correct that by importing to Excel using From Text wizard or Power Query.