topic Re: How to import all excel data to geodatabase ? in ArcGIS Pro Questions

How to import all excel data to geodatabase ?

AliAzzouhri1 — Mon, 22 Jul 2019 06:39:32 GMT

Hi everyone what is the best way to make the target fields matching the source fields automatically because I have more than 100 fields,

The fields in File Geodatabase and Excel have the same name.

Thank you

______________________________

Re: How to import all excel data to geodatabase ?

KoryKramer — Mon, 22 Jul 2019 08:59:54 GMT

Have you tried Excel to Table with your Feb as the output location?

Excel To Table—Help | ArcGIS Desktop

Re: How to import all excel data to geodatabase ?

AliAzzouhri1 — Mon, 22 Jul 2019 11:23:42 GMT

yes, I did but some field still empty...

Re: How to import all excel data to geodatabase ?

JoeBorgione — Mon, 22 Jul 2019 13:54:49 GMT

What is your workflow? It appears that you have created an empty table based on the schema of your excel worksheet, and are then using the simple data loader to move the data from excel into that new table: is that correct?

As Kory Kramer‌ suggests, my first approach would be to use the excel to table tool. Can you elaborate as to how you are using this and what fields are 'empty'. A second approach worth trying is the append tool. Again as it appears you have an empty table you wish to add your excel data to, use append with the NO TEST option and your fields should map automatically.

Re: How to import all excel data to geodatabase ?

AliAzzouhri1 — Tue, 23 Jul 2019 06:25:13 GMT

I have a standard Geodatabese forme government (surface groundwater) that I should fille from the site data (Asbuilt) so I have the data in excel sheet, I create Point from the coordinate, but more than 50 rows thas not show in my standards geodatabase, anyway thank you I will tray manually,