Importing Access DB

[Kuroshi]

Hi guys,

I have a simple question to make sure that it will work. If I import my Access Database in Caspio and the fields have '-' and '()' in the field names, also if some of the field DataType is set to 'OLE Object', this will be successfully imported in Caspio, right? Or should I remove/change every field?

[Barbie]

Hi again @Batchini,

I tested this on my end and confirmed that even if you have special characters such as dash (-) and/or using ‘OLE Object’ as a DataType, Caspio will automatically fix it once imported. For the  OLE Object, it will be automatically change as Text(64000) once imported. 

I hope this helps. 

- Barbie

[Barbie]

Just to add, you may also refer to this article for more information about importing: 

https://howto.caspio.com/tables-and-views/importing-data/

[ParkLoey]

Hi! Just wanted to let you know guys that as of April 1, 2024, import/export from ms access will no longer run or work because it is now deprecated. more information can be found here: https://howto.caspio.com/deprecations/deprecation-of-ms-access-for-import-export/