Export to Access

Would like to know anyone knows how to create the ability to export to Access
from RS web. Maybe making it available in the dropdown. We are reaching the
limitations of excel and would like to automate it saving as table in access.
ThanksAndrew,
I'm not sure if you can get to access from RS directly but a
possible way round it would be to set up a subscription in RS to save the
output as a csv file on a fileshare at regular intervals. You could then
import the csv file into access as a table.
Hope this helps.
Nick Colebourn
"Andrew" wrote:
> Would like to know anyone knows how to create the ability to export to Access
> from RS web. Maybe making it available in the dropdown. We are reaching the
> limitations of excel and would like to automate it saving as table in access.
> Thanks|||RS doesn't export to MS Access. As Nick said you can export to CSV or since
you are already exporting to Excel then import those files into Access.
"Nick Colebourn" <NickColebourn@.discussions.microsoft.com> wrote in message
news:2A6D94F2-099F-426E-9335-49C779F4747B@.microsoft.com...
> Andrew,
> I'm not sure if you can get to access from RS directly but a
> possible way round it would be to set up a subscription in RS to save the
> output as a csv file on a fileshare at regular intervals. You could then
> import the csv file into access as a table.
> Hope this helps.
> Nick Colebourn
> "Andrew" wrote:
> > Would like to know anyone knows how to create the ability to export to
Access
> > from RS web. Maybe making it available in the dropdown. We are
reaching the
> > limitations of excel and would like to automate it saving as table in
access.
> > Thanks|||I have a similar problem. I want to automatically have an excel file imported
into access without user intervention. Is this possible?
"Brian Bischof" wrote:
> RS doesn't export to MS Access. As Nick said you can export to CSV or since
> you are already exporting to Excel then import those files into Access.
>
> "Nick Colebourn" <NickColebourn@.discussions.microsoft.com> wrote in message
> news:2A6D94F2-099F-426E-9335-49C779F4747B@.microsoft.com...
> > Andrew,
> > I'm not sure if you can get to access from RS directly but a
> > possible way round it would be to set up a subscription in RS to save the
> > output as a csv file on a fileshare at regular intervals. You could then
> > import the csv file into access as a table.
> >
> > Hope this helps.
> >
> > Nick Colebourn
> >
> > "Andrew" wrote:
> >
> > > Would like to know anyone knows how to create the ability to export to
> Access
> > > from RS web. Maybe making it available in the dropdown. We are
> reaching the
> > > limitations of excel and would like to automate it saving as table in
> access.
> > > Thanks
>
>