Hi Team,
How do I convert .DBF file to CSV
Tried it to rename but data after 10lakhs is not converted
Any method or approach to do this
Regards,
Supriya Yenaganti
Hi Team,
How do I convert .DBF file to CSV
Tried it to rename but data after 10lakhs is not converted
Any method or approach to do this
Regards,
Supriya Yenaganti
Can you open the file in excel and save it via that route?
Hi @TimK
Did by opening excel but some data goes missing
How many data items / rows are there on dbf file?
You’ll need to read the data into datatable variables and then write it back out to CSV.
What activity will I use to read the dbf fie and store it in databale
File is around 300mb so cannot be attached
Excel can read dbf files, so open it in Excel, save it as an Excel file, then use the Excel activities to read it.
Hey @supu123
Did you try with Read Excel or CSV activity and Write again back using UiPath ?
Also, please show a small snap of how dbf file data looks like…
Thanks
#nK
while using read csv or excel getting an error
“Read CSV: The CSV file format for C:\Users\Venkatesh Yenaganti\Desktop\ICICI\file2 - Copy.DBF is invalid. Line 3 contains more values than the header line.”
Hello @supu123
Can you make a dummy copy of dbf file which of small size and attach here.
Else can you share a screenshot of the file here. Need to see how the file looks
shared drive link file2 - Copy.zip - Google Drive
Thanks and Regards,
Supriya
Excel only supports max 1,048,576 rows which might explain why data after 10 lakhs is missing.