If you use insert from then you don't need drop part (or if autoinc is not in text file). I think the insert would do the memo field correct Insert from temp (fieldname1, fieldname2, fieldname3,fieldname4,fieldname5,fieldname6,fieldname7) readwriteĪlter table temp drop column aincfield - maybe don't need Select * from mytable into cursor temp where. (I don't get the text file part) 0,"Field1Value",Field2value" If I were to enter this from the command window, I would type I took the autoincrementing field out of my text file. Easier ways are to use SQLExec() or OLEDB transfers. With text file in between you can't address a memo field (unless you do lowlevel file operations). readwriteĪppend from mytextfile.txt type delimited Select * from myTable into cursor temp where. Then create a temporary cursor that matches the structure of your table and format of text file. Oh I thought you were directly appending from SQLExec() result. Currently the field is a text field in Access. Where does the gather fit into this Gather memvar fields from special.txt And how do I address the memo field in the record. I have data in an MS Access application that needs to be imported into the FoxPro DBC Specials.dbf file. I do not have the source code for this application just the DBC with DBF files.
txt file and still get an error message saying it the Spe_pk is compromised and a zero is in the record. The file with records to import is in special.txt I left the autoincrement field off the. I have tried using append from and I get a zero in the autoincrement field. If you try to modify or add a value into it, you will get an error. In FoxPro autoincrement field is always readonly. Weird sgows up as no one replied:( Anyway luckily I could copy using back: Select * from VFPcursor into cursor xx readwriteĪlter table VFPCursor drop column autoincCol SQLExec(m.nHandle, "select * from AccessTable","VFPCursor") & list all fields except autoincĪnother way is to alter table command (wouldn't work if there are any longfieldnames): For example when getting directly from access: I would like to append using a text file or excel file from MS Access table Or import directly from Access to FoxPro.ĭrop the autoinc field from the list. Any suggestions on how to append or insert records would be helpful. The autoincrement field always defaults to zero and produces an error message. I would like to append records to this file. Posted: Visual FoxPro General, appending data into an existing DBF with an autoincrement field
Index ‹ Visual FoxPro ‹ Visual FoxPro General Appending data into an existing DBF with an autoincrement field
0 kommentar(er)
