topic Re: Convert .DAT file to table (sde) in Geodatabase Questions

Convert .DAT file to table (sde)

AlexP_ — Mon, 05 Apr 2021 16:21:38 GMT

Hello,

I have sde, ArcGIS pro 2.7.2. I received .DAT data file. It is actually table. How can I convert it to sde table or FGDB table? I am unable to find any conversation tool for .DAT. Please advise.

Thank you.

Alex

Re: Convert .DAT file to table (sde)

JayantaPoddar — Mon, 05 Apr 2021 16:28:10 GMT

Can you open the file in an Excel Sheet? If yes, follow these steps

1. Check if the FieldNames are simple, and properly structured. Save the file as Excel file (*.xlsx).

2. Use Excel to Table to convert the above file to SDE table

Re: Convert .DAT file to table (sde)

AlexP_ — Mon, 05 Apr 2021 17:45:48 GMT

Hello @JayantaPoddar

Thank you for the information. It is still loading to excel. I have a feeling it might crash due to large file. The size is 1,096,293 KB. Do you have any other method?

Re: Convert .DAT file to table (sde)

George_Thompson — Mon, 05 Apr 2021 17:45:45 GMT

What program did the .DAT file come from?

Re: Convert .DAT file to table (sde)

AlexP_ — Mon, 05 Apr 2021 18:42:04 GMT

@George_Thompson @JayantaPoddar I am not sure. I received this data from the county. I have been informed it is a table.

Re: Convert .DAT file to table (sde)

George_Thompson — Mon, 05 Apr 2021 18:44:20 GMT

it may be useful to ask what program they exported it from. I did a quick Google search and found this: https://www.howtogeek.com/363326/what-is-a-dat-file-and-how-do-i-open-one/

I would ask them for a CSV or Excel file as the export.

Re: Convert .DAT file to table (sde)

VinceAngelo — Mon, 12 Apr 2021 19:15:19 GMT

Friends don't let friends use Excel for data transfer (especially large data transfer). CSV is much less likely to be mangled.

- V