![]() |
Excel and Access link
I am using MS Excel to handle my transactions but with my present rate of
data, I will reach the limit in terms of number of rows of one spreadsheet, ie. 65,000+, in no time. Is it possible that I use MS Access as my database but processing will be done in Excel? I am not familiar with MS Access that is why I use Excel but did not foresee the rate of population. Or is there a way where I can stretch the limit of Excel. Thanks |
Excel and Access link
Rook wrote:
I am using MS Excel to handle my transactions but with my present rate of data, I will reach the limit in terms of number of rows of one spreadsheet, ie. 65,000+, in no time. Is it possible that I use MS Access as my database but processing will be done in Excel? I am not familiar with MS Access that is why I use Excel but did not foresee the rate of population. Or is there a way where I can stretch the limit of Excel. Thanks Hi Rook, See this link: http://support.microsoft.com/default...b;en-us;120596 -- Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
Excel and Access link
Franz,
Thanks for the help. Rook "Franz Verga" wrote: Rook wrote: I am using MS Excel to handle my transactions but with my present rate of data, I will reach the limit in terms of number of rows of one spreadsheet, ie. 65,000+, in no time. Is it possible that I use MS Access as my database but processing will be done in Excel? I am not familiar with MS Access that is why I use Excel but did not foresee the rate of population. Or is there a way where I can stretch the limit of Excel. Thanks Hi Rook, See this link: http://support.microsoft.com/default...b;en-us;120596 -- Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
All times are GMT +1. The time now is 05:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com