I would like to have an application that will import files into an access db (back end)
Preferrably, I would have one Admin form (password locked) to store static values of
Db Info
_______
DB Name
DBPath
db Type
File Info
______
File Name
File Type
File backuppath
Depending on the options chosen, we can use as connection strings/path etc...in order to use in connection strings in the db
The file to be imported will be chosen from a different form (File Import)
File Import form will have a button to allow the end user to select.
once selected, the file will be imported to the table, timestamped, and moved to the backup path
The destination db will initially be MS Access (mdb)
I want this application to be built with something other than access - I will be migrating to sql server so i need the scalability. An access front end is ok if economical but C# .net application is preferred.
In the end, I will want to have all of the code, and comments in US English. All source code will be open (unencrypted)
I have two files. A customer file and a sales file
From the Customer file, a unique customer list is to be built. No truncation, just addition of new customers and updates to records of changed customers
Sales file - this file will be used to build a product file - unique records only.
Sales Table a Table with Customer, Date, and QTY.
Hello Sir,We can do it in VB6.0 ,Recently we have completed similar project of Transferring data from csv file to Access Data base to MYSQL Data base of PHP Website again Selected data to access data base,We are Expert in access,SQL,MYSQL apart from VB6.0 in which we can do anything,Please see PM
Hi,
i can do this. I already made few applications like this one - simple read xls data and store to mdb.
I have 4 years of experience in .net development, databases and business applications with similar use like yours.