CODEWITHSUNDEEP
ms-access
gavra
gavra

Reputation: 93

Import to Local database from access

I am developing a new system. the old one uses access database which is pretty horrible considering the large amount of data stored there and the amount of people using the program. So I thought it might be better to use the Local database item (Add new item > Data > Local Database) that visual studio offers and place it on a shared folder (just the same way the access db is used with the old program [a server is not an option right now]). I was wondering if there is a way to import the data and tables from the access contains to the Local database I add to my project? (maybe through an exported file from the access like ODBC file)

Thank you very much.

Upvotes: 2

Views: 2086

Answers (1)

Tim Lentine
Tim Lentine

Reputation: 7862

I could be wrong, but I am fairly certain that a local database in VS as you have described it will be adding a SQL CE database which becomes embedded within your application and would not be comparable to an Access database on a file share somewhere on your network. You probably are looking at a minimum of using SQL Server Express for this type of design. If you do use SQL Server Express, you can "upsize" the Access database to SQL Server easily enough using Microsoft Access.

Upvotes: 2

Related Questions