Creating fields by importing from Excel

Yes, during the import dialogue screens it will guess at your field types, but you may override Quick Base's guesses.

Hi Thanks, I understand, however that is very manual, I am looking to create a large number of fields mainly as numeric rather than text so would like to control this directly from the import. I am hoping there is a way I can define each column so it automatically "guesses" as Numeric. Hope this makes sense.

if you do an initial upload or a few rows with dummy values which are clearly numeric, then the fields will be guesses as numeric.

Then the real import will already have the fields created and will map to those field names.

Hi, Thanks,  I did think about that as a solution, just need to work out the right way to do so and not impact anything. I am tinkering with an existing live DB, never designed to do what is needed now :)

Many thanks,  food for thought.