PDA

View Full Version : Solved: Advice and Help which database to use



Rob342
10-19-2012, 12:53 AM
Hi
I have a project that uses a Multipage form & is currently writing 3000 + records a month.
In the experts opinion, which would be a better way to achieve this goal.
bearing in mind that it will be neccessary to read the file at a later date.
I am trying to keep the database seperate from the main excel programme
so i dont have any problems updating it at a later stage ( no data to worry about)

1 Write the data to a seperate workbook, keep it all in excel
2 Write the data to a text file
3 Use access as a database ( no experience with access) and users have not got access

4 Is it quicker to read data from excel ?
5 Is it Quicker to Write & read data from a text file and how would the records be configured.

Many thanks to all
Rob
Enclosed is a sample heading of the record and a flowchart in what i'm trying to achieve.

mohanvijay
10-19-2012, 12:58 AM
you can use MS Access database.

Users need not MS Access to use it

I use MS access for my VBA application.My Access database contains 12 Tables and writing 5000 + records per month.it is working very fine to me

Rob342
10-19-2012, 01:07 AM
Mohanvijay
Thanks for reply, do you have any sample code of how to read & write to access as i have never dealt with access before?
Rob

mohanvijay
10-19-2012, 01:19 AM
Refer ADODB Objects

http://msdn.microsoft.com/en-us/library/windows/desktop/ms676795(v=vs.85).aspx

snb
10-19-2012, 03:17 AM
If you are familiar with Excel I see no reason not to store the data into a separate Excel file. 3000 records a month is not excessive (a worksheet contains ca. 1.048.000 rows; so you have a long time to go before all rows of just 1 worksheet are being filled)

Kenneth Hobs
10-19-2012, 01:23 PM
Read and write ADO:
http://www.erlandsendata.no/english/index.php?t=envbadac

Rob342
10-21-2012, 09:23 AM
Thanks Guys

A few things to mull over

Rob