Does anyone know how to convert a .accdb file into a SQLite compatible format?
I am looking to migrate an existing DB from Access to an app I am writing to add and retrieve the information for me without having to manually enter the stuff into 4 different tables.
Not sure what you are actually doing. Are you wanting to export the data from Access into SQL Server 2005 Express?
If so, you should be able to use the (on the EXTERNAL DATA Tab) EXPORT > MORE > ODBC DATABASE to send the tables to SQL Server.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.