Appending Table

[nabi]

Hello All,

I am a novice with Caspio Bridge but I am very impressed by the capabilities it gives you to build database driven web forms.

I am sharing all the new things I come up with working with Caspio Bridge so that the community can add if I missed something or if there is a better way to do.

I realized that when you are importing an Excel file and you want to append to the existing file, you make sure that the field title be there in the file you want to import. Otherwise, it will not give you the option to append or replace existing file but only create new file.

Any comments ?

[davep]

Also, if you have any new fields in your imported file, they will be added to the table structure.

[MattS]

I'm trying to figure out a way to automatically append data from MS Access into an existing Caspio table.

I would like users to be able to click a button and have this done without having to worry about someone overwriting the table rather than appending to it.

I'd prefer to do this from within my MS Access app, but am willing to write something in VB6 if that's needed for the job.

[bmccarrie]

I think I've tried everything. I've copied tables with the exact data format and tried to import and append. I get the option to create a new table but I don't get the option to append the data. This is driving me mad. Any insight here?

Thanks!

[bahar_vm]

Hi,

Caspio Professional Service department could custom program this feature to automatically append data into a Caspio table, please call the Sales to provide more details and get a quote.

Regarding appending a table, as long as the header row of the CSV file contains the correct field names, the append and replace options are available.

Best,

Bahar M.

[MattS]

Is there any way to interact with a Caspio database by using Access and ODBC, as is possible with MySQL?

Thanks

[bahar_vm]

Hi Matt,

Data interaction is possible using Caspio Bridge plug-in. You could have one way synchronization from your Caspio Bridge database to your local Access database. To get the plug-in and web services please apply online at http://howto.caspio.com/extensions/casp ... ms-office/

Best,

Bahar M.

[NailDyanC]

Hi, here is the new and updated link for getting the plug-in in Microsoft Office: https://howto.caspio.com/integration/plugin-for-microsoft-office/