Forum Discussion

AdamKeever1's avatar
AdamKeever1
Qrew Commander
6 years ago
Solved

Import Record Limitation?

I need to import 150,000 records into a table. The records contain simple text, date, and numeric fields with a total of 14 fields. I get an error message when I try to import the records: I ...
Data import and export
records
  • EvanMartinez's avatar
    EvanMartinez
    6 years ago
    Hi Adam,

    I see that error message pop up most often when it is an Excel (XLSX) type file that has some styling that confuses QB on upload. That error usually goes away as soon as I save it over as a CSV file instead, as that clears up the styling that holds up the import. There is a limit to the size of an import but you usually get a different error message when you have reached that limit that is more explicit. If you save it over to a CSV file type do you still get the same error?

    ------------------------------
    Evan Martinez
    Community Marketing Manager
    Quick Base
    ------------------------------
EvanMartinez's avatar
EvanMartinez
Quickbase Staff
6 years ago
Hi Adam,

I see that error message pop up most often when it is an Excel (XLSX) type file that has some styling that confuses QB on upload. That error usually goes away as soon as I save it over as a CSV file instead, as that clears up the styling that holds up the import. There is a limit to the size of an import but you usually get a different error message when you have reached that limit that is more explicit. If you save it over to a CSV file type do you still get the same error?

------------------------------
Evan Martinez
Community Marketing Manager
Quick Base
------------------------------