Solved: Advice and Help which database to use

[Rob342]

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]

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]

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]

Refer ADODB Objects

http://msdn.microsoft.com/en-us/libr...(v=vs.85).aspx

[snb]

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]

Read and write ADO:
http://www.erlandsendata.no/english/...php?t=envbadac

[Rob342]

Thanks Guys

A few things to mull over

Rob