Skip to main content
Question

Creating fields by importing from Excel

  • November 20, 2018
  • 0 replies
  • 49 views
Hi, I want to import from Excel to create new fields in a table, which I can do, however is there a way to control the field type it creates ? (I am not importing data at the same time, just using Excel as a vehicle to create the fields) Thanks.
    This topic has been closed for replies.

    Yes, during the import dialogue screens it will guess at your field types, but you may override Quick Base's guesses.
    • MikeWoodcock
    • Author
    • Registered
    • November 20, 2018
    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.
    • MikeWoodcock
    • Author
    • Registered
    • November 20, 2018
    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.
    Terms & ConditionsAccessibility statement