Forum Discussion

Qrew Champion

4 years ago

Finding Non-breaking spaces in imported data

We have an import tool that takes an Excel spreadsheet and imports the data into Quickbase. We find there is an ASCII character char(160) that looks like a regular space but is read differently by ot...

Data import and export

Qrew Captain

4 years ago

I dont have an answer but was wondering what tool you use to import the excel sheet into QuickBase?

------------------------------
Mike Tamoush
------------------------------

JimHarrison
Qrew Champion
4 years ago
Hi Mike,

We use ConvertAPI and Zamzar to go from xlsx to csv.

Regards,
Jim Harrison
Portland, OR

------------------------------
Jim Harrison
transparency = knowledge + understanding : The Scrum Dudes
------------------------------
- MichaelTamoush
  Qrew Captain
  4 years ago
  Does one of these programs actually automatically import the data into QB? ie the equivalent of clicking 'import from file'?
  
  ------------------------------
  Mike Tamoush
  ------------------------------
  - JimHarrison
    Qrew Champion
    4 years ago
    No for that we use Workato, which is like Pipelines.
    
    Regards,
    Jim Harrison
    Portland, OR
    
    ------------------------------
    Jim Harrison
    transparency = knowledge + understanding : The Scrum Dudes
    ------------------------------