ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   moving an Access form to Excel (https://www.excelbanter.com/excel-programming/345959-moving-access-form-excel.html)

JT

moving an Access form to Excel
 
Is it possible to move an Access (2000) form into Excel (2003) or do I have
re-build the form in Excel. Thanks for the help........Mike
--
JT

JT

moving an Access form to Excel
 
Thanks for the info...but I'm not collecting or aggregating any data in
Access. I only use an Access form to ftp a txt file from a web site. Since
the form was already built in Access I was using that but manipulating the
data in Excel takes much longer from Access.

I was trying to save time by moving the form to Excel instead of recreating
it.....
--
JT


"TomHinkle" wrote:

A) why would you want to do this??
Access is the right tool for data collection/aggregation.

if it were up to ME, I'd keep the data access form in access and if you have
to have reporting in excel, just 'push' the data to excel after it has been
input.

You can't really build the same form in Excel, it's not a data collection
tool, it's more designed for analysis.



"JT" wrote:

Is it possible to move an Access (2000) form into Excel (2003) or do I have
re-build the form in Excel. Thanks for the help........Mike
--
JT



All times are GMT +1. The time now is 05:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com