I have a Calc spreadsheet with one column of about 700 records that I would like to import into a field in a Base form to create records. Is there a way to do this and then be able to add data into the other boxes on the form?
Hello,
You cannot add more than one record at a time in a form. Therefore, you would have to copy & past each one - that is 700 x’s. However ----
Data can be appended to an existing table depending upon the structure of the table. Since you are dealing with a single column (one field) the table would need to be structured that the Primary Key is an auto-increment field (unless this data is the primary key) and that with the remaining fields, none are required fields. Even with this, possible to modify the table structure, add the data the set the structure back to its’ original setting.
To do this, the first line of the column should be the field name. Then select all the data from spreadsheet column (copy) then paste into the table wanted (right click on table name). On the first dialog make sure table name is correct & that append data & Use first line as column name are selected. Then just step through (Next button) the process making sure the data is placed in correct table field.
Thanks. I wish I had waited until today to do the 700 copy and pastes! I will try it on a backup copy of the Base file to learn how to do it for future reference. Also, I need help figuring out what I am leaving out of the process of using list boxes with drop down. I have set up the controls and the relationships with the primary and foreign keys, etc (to the extent that I understand anyway), but nothing shows up when trying to use them. Got any advice? Thanks again. John
Please do not post as answer unless it is to respond to original question. Use comment instead.
Please refer to other post for your other question. Forum is set to ask a question & get an answer. Multiple questions in same post does not go well for searching.