File Conversion Query

Help Studio
, ,
1

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

1 Like
2

Can you open the file in excel and save it via that route?

1 Like
3

Hi @TimK

Did by opening excel but some data goes missing

1 Like
4

Hey @supu123

Could you please show or attach a dbf file here to check ?

Thanks
#nK

5

How many data items / rows are there on dbf file?

6

You’ll need to read the data into datatable variables and then write it back out to CSV.

7

What activity will I use to read the dbf fie and store it in databale

8

@Nithinkrishna

File is around 300mb so cannot be attached

1 Like
9

Excel can read dbf files, so open it in Excel, save it as an Excel file, then use the Excel activities to read it.

10

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

11

Hi @Nithinkrishna

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.”

12

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

13

Hi @Rahul_Unnikrishnan

shared drive link file2 - Copy.zip - Google Drive

Thanks and Regards,
Supriya

14

Excel only supports max 1,048,576 rows which might explain why data after 10 lakhs is missing.

image