ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Importing information into Excel (https://www.excelbanter.com/excel-discussion-misc-queries/254364-importing-information-into-excel.html)

confused in PDX

Importing information into Excel
 
Can you create a form that has fields that can be exported into Excel? or
even an Access database? I created a form in Word, saved it as a txt file
and then imported it into Excel, but that didn't work. It seemed to work in
Office 2003 but not 2007.

Gord Dibben

Importing information into Excel
 
How did you "import" and what is "didn't work"?

You open a *.txt file in Excel you should get the Text Import Wizard popping
up so's you can parse the text.

Works for me in 2007


Gord Dibben MS Excel MVP


On Mon, 25 Jan 2010 16:33:01 -0800, confused in PDX <confused in
wrote:

Can you create a form that has fields that can be exported into Excel? or
even an Access database? I created a form in Word, saved it as a txt file
and then imported it into Excel, but that didn't work. It seemed to work in
Office 2003 but not 2007.




All times are GMT +1. The time now is 08:36 PM.

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