ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Links and Linking in Excel (https://www.excelbanter.com/links-linking-excel/)
-   -   Excel and Access link (https://www.excelbanter.com/links-linking-excel/110367-excel-access-link.html)

rook

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




Franz Verga

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



rook

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