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.
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.