Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
import access to excel template Glenn Excel Discussion (Misc queries) 3 March 13th 09 01:16 PM
Import into Excel Template from Access db clk Links and Linking in Excel 0 January 8th 09 01:35 PM
How do I import and filter worksheets into a template? fab Excel Discussion (Misc queries) 1 October 15th 06 08:06 PM
Is there a way to import a spreadsheet into a calendar template? Deanna Excel Worksheet Functions 0 May 25th 06 07:32 PM
looking for a calendar template that I can import multiple dates bkrizman Excel Discussion (Misc queries) 0 June 1st 05 11:16 PM


All times are GMT +1. The time now is 04:44 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"