Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import template
I use Excel 2002 on a Windows XP system.
I would like to be able to export tabular data from a FileMaker database, and then import it into a pre-formatted Excel worksheet to save all the work of formatting. I would like to pre-format column widths, row heights and fonts. I know how to create the template, and I can create the exports, but how can I import the data from say a tab delimited file, or perhaps an htm file? -- John Garate 610-687-3011 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import template
Import it into a new workbook (Just open the file in the workbook - use the
text import wizard to get it in the proper columns. ). Select the data and do Edit=Copy, then go to the template and select A1, do Edit=Paste Special and select values. -- Regards, Tom Ogilvy "John Garate" wrote in message ... I use Excel 2002 on a Windows XP system. I would like to be able to export tabular data from a FileMaker database, and then import it into a pre-formatted Excel worksheet to save all the work of formatting. I would like to pre-format column widths, row heights and fonts. I know how to create the template, and I can create the exports, but how can I import the data from say a tab delimited file, or perhaps an htm file? -- John Garate 610-687-3011 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
import access to excel template | Excel Discussion (Misc queries) | |||
Import into Excel Template from Access db | Links and Linking in Excel | |||
How do I import and filter worksheets into a template? | Excel Discussion (Misc queries) | |||
Is there a way to import a spreadsheet into a calendar template? | Excel Worksheet Functions | |||
looking for a calendar template that I can import multiple dates | Excel Discussion (Misc queries) |