If you have built a custom student or membership database in Microsoft Access, you can export this data and import it into Spark. Follow the steps below to export your database tables.

Please note: This guide is for custom-built Access databases. If you are unsure whether this applies to you, please reach out to us at [email protected] before proceeding and we'll help you figure out the best path forward.

In the Navigation Pane of the source database, select the object that you want to export.

In the Navigation Pane, select the table you want to export.
Click External Data > Export > Excel, select Excel as your file format and click OK.
Repeat this process for each table in your database.

Once you have exported all your tables, please send them to our data team at [email protected]. Please include your Spark ID in your email, which can be found in the top left corner of your Spark software. This helps us identify your account quickly.

Microsoft Access does not store financial data. If you have a different software you use to charge your contacts, please let us know and we can look into this for you. We recommend using Spark's Credit Card Recollection feature to recollect card information from your customers. https://help.sparkmembership.com/en/articles/9859920-credit-card-recollection-feature

Which tables should I export? If you are unsure which tables to export, please reach out to us at [email protected] before sending your files and we'll help you identify the relevant ones.

How long does the import into Spark take? Once we receive your files, your data will be imported within 2 business days.

What if my column names are different from what Spark expects? Our data team can help map your columns to Spark's fields. Please reach out to us at [email protected] if you need assistance.