Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.links
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.links
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing EXCEL Spreadsheets into ACCESS -- Macro or VBA? | Excel Worksheet Functions | |||
Importing EXCEL Spreadsheets into ACCESS -- Macro or VBA? | Excel Discussion (Misc queries) | |||
how do i set up a link between one excel cell from an access cell | Excel Discussion (Misc queries) | |||
link Access workbook to Excel workbook | Excel Discussion (Misc queries) | |||
Link Access query to refresh an EXCEL file | New Users to Excel |