How do I update a field (column) across numerous records in my database from a CSV file? In other words how do I do an update query in QuickBase?

Knowledge Base

Our Knowledge Base covers a wide variety of technical topics, from the basic to the complex.

If your CSV file has a column in it that maps to the key field of the table then all you have to do is import the CSV file into QuickBase. Please read the following help topic:

https://www.quickbase.com/help/importing_data.html

If your CSV file doesn't have a column that maps to the key field in QuickBase, but it does have a column that maps to a unique field in your QuickBase table then you can temporarily or permanently switch the QuickBase key field to the unique field to do your update via import.

To learn more about changing the key field please read the following:

https://www.quickbase.com/help/setting_the_key_field.html

Tags:

Comments

Post new comment

Your name: *

E-mail: *

The content of this field is kept private and will not be shown publicly.

Homepage:

Subject:

Comment: *

Input format

Filtered HTML

Web page addresses and e-mail addresses turn into links automatically.
Allowed HTML tags: <a> <p> <hr> <br> <br /> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <em> <b> <u> <i> <strong> <font> <del> <ins> <sub> <sup> <quote> <blockquote> <pre> <address> <code> <cite> <embed> <object> <param> <strike> <caption> <img> <h1> <h2> <h3> <h4>
You may post code using <code>...</code> (generic) or <?php ... ?> (highlighted PHP) tags.
You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <c>, <cpp>, <drupal5>, <drupal6>, <java>, <javascript>, <php>, <python>, <ruby>, <xml>. The supported tag styles are: <foo>, [foo].
Images can be added to this post.

Plain Text

Web page addresses and e-mail addresses turn into links automatically.
Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>

More information about formatting options

Word verification: * Type the characters you see in this picture.

(verify using audio)

Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.

Printer-friendly versionSend to friend

Knowledge Base