*Download*

Download and unzip the file sqlite_source.zip. Do not use the .tar.gz files because they have not been pre-processed for use with Windows.

*Create a starter DLL project*

1. File > New > Project

2. Under Project Types, select Visual C++ Projects and then Win32.

3. Choose the project template "Win32 Project".

4. Give the project a name and click OK.

5. When the "Win32 Application Wizard" appears, choose Application Settings. set the Application Type to DLL and check the box that says "Empty project". Click Finish. You now have a blank DLL project.

*Add the SQLite files to the project*

7. Project > Add Existing Item

8. Add all the .c and .h files that you unzipped, except for: tclsqlite.c and shell.c.

*Make a .DEF file*

9. Create a new file called sqlite.def in the project directory. The contents of sqlite.def should be:

   EXPORTS
   sqlite_open
   sqlite_close
   sqlite_exec
   sqlite_last_insert_rowid
   sqlite_error_string
   sqlite_interrupt
   sqlite_complete
   sqlite_busy_handler
   sqlite_busy_timeout
   sqlite_get_table
   sqlite_free_table
   sqlite_mprintf
   sqlite_vmprintf
   sqlite_exec_printf
   sqlite_exec_vprintf
   sqlite_get_table_printf
   sqlite_get_table_vprintf
   sqlite_freemem
   sqlite_libversion
   sqlite_libencoding
   sqlite_changes
   sqlite_create_function
   sqlite_create_aggregate
   sqlite_function_type
   sqlite_user_data
   sqlite_aggregate_context
   sqlite_aggregate_count
   sqlite_set_result_string
   sqlite_set_result_int
   sqlite_set_result_double
   sqlite_set_result_error
   sqliteMalloc
   sqliteFree
   sqliteRealloc
   sqlite_set_authorizer
   sqlite_trace
   sqlite_compile
   sqlite_step
   sqlite_finalize

10. Add the sqlite.def file to the project.

11. Under Project > Properties navigate to the Linker folder and choose "Input". In the field that says "Module Definition File" type sqlite.def. NOTE: You have to do this twice, once for the Debug configuration and once for the Release configuration.

12. *Compile!*

*How to make the SQLITE.EXE command-line utility*

There are some slight changes if you wanted to build the sqlite.exe command-line utility, instead of the DLL. To do that, when you're creating the project and you get to the "Win32 Application Wizard", choose "Console Application" instead of "DLL". Then, when you are adding files to the project, also add shell.c. Finally, don't include the .DEF file.