Can I be reminded of my friend's birthday via e-mail?
save a flat export data file as an excel file
Hello Guest		   
  • Login
• Register…
• Start blog		   • Who, Where, When
• What can I do?
• What to Read?		   • Polls
• Avatars
• Interests		   • Cities and Countries
• Random blog
• Users search		   • Search
• Games
• Tests
• QAIX		   • Сообщества
• Talxy Chat
• Horoscope
• Online		  
Зарегистрируйся!
QAIX > ASP web-programming > save a flat export data file as an excel file 17 July 2008 11:27:59
  Recent blog posts: 
_4_
…

mego day!
:-O­ yesss I today went for a walk from a 6 morning! it super! so merrily that pipec!

Everybody is a book
Everybody is a book, parents are our publishing houses, and our publication time on birthday, the ID…

boring..boring...boring :-|…
boring..boring...bor­­ing :-|­ where people? bitchs...not abandon me one…

here so quietly and boring! on…
here so quietly and boring! on beone merrier far! well but I can sit in a quiet.... and not who by the…

Transfer iTunes Library to Zune
If you have moved from Apple iPod to Microsoft Zune, you probably have some songs that you purchased&hellip­;

hello!
hello!I here new! interestingly me what people dwell on this site... I search friends from the command…

Routes on Sale!
Looking for great Quality/Competitive­­ Rates???? Breezecom FZC is offering: PAKISTAN! CLI…

Hello!
Hello!

How to rip DVD and convert…
You may have at hand many fantastic DVD movies and video files, which you definitely love very much…

  Forums:   
    topic feeds

• QAIX  all topics, blogs and comments

• PHP web-programming

• Perl web-programming

• ASP web-programming

• Visual Basic Programming

• .Net Development

• C/C++ Programming

• Java Programming

• Javascript web-programming

• Apache HTTP Server

• Web-design

• Web-hosting, dedicated, colocation

• HTML web-programming

• XML development

• General Web-programming

• Content Management Systems

• ColdFusion

• Search Engine Optimization

• Hardware

• Software, Computer Help

• MySQL database development

• PostgreSQL database development

• MS Access database development

• Oracle database development

• MS SQL database development

• Informix database development

• Buy / Sell

• Open discussion

• Anonymous
  Discuss: 
Select Records between…
I've built a Point-of-Sale using "classic" asp (it's what I know) and I'm trying to get daily…

Borwser prompts for…
I have put together a very simple internal web site that runs on Windows 2003 Server. Anonymous access…

Possible to include SSI in ASP…
Hi, We want to include some SSI in our ASP pages, but where the SSI is located on a different server…

text wait or hourglass
Hi Can someone please help me with the following: I have an ASP-page where a query runs, it…
  Recent forum topics: 
r24799 - docs/Perl6/Spec
Author: particle Date: 2009-01-07 20:53:32 +0100 (Wed, 07 Jan 2009) New Revision: 24799 Modified…

r24798 - docs/Perl6/Spec
Author: particle Date: 2009-01-07 20:42:33 +0100 (Wed, 07 Jan 2009) New Revision: 24798 Modified…

Writing to an iterator
I was just reading through S07, and it occurred to me that if one wanted to, one could handle stacks and…

ServiceController status…
This is a repost from CLR, doesn't seem like there is much activity over on that list. This isn't…
  Recent forum comments:
RE: NEW NEOPOINT GENERATOR v2…
Is it really that hard to hack neopets? I figure someone must of done something about that O:

RE: Re: What happened with…
$ svn info lib/Apache2/Reload.­pm Path: lib/Apache2/Reload.­pm Name: Reload.pm URL…

RE: Can I have multiple child divs?
I don't understand your question. The button bar appears stable to me. -- Murray MVP Expression Web…

RE: Can I have multiple child divs?
It is related to the white space issue at the bottom. If I try to move the tables up to get rid of the…

RE: Frustrated, Frontpage…
Sixbells;9207716 Wrote: I would use a decent package such as Dreamweaver or if you cant afford it go…

RE: Frustrated, Frontpage…
and that would fix it, eh? -- ~~~~~~~~~~~~~~~~~~ Rob Giordano Microsoft MVP Expression…

RE: Frustrated, Frontpage…
I will re-write it with nested tables, a good do over usually results in better code anyway. But one…

RE: Frustrated, Frontpage…
Don't use the draw table tool. That will add height attributes to everything (tables and table cells)…

RE: change text color
Use the Date Diff functionSee…

RE: Drop down is not displaying…
I have talked to my boss and we do not want the top frame larger, so we are going to re-develop the…
  Moderators:
 Administrator
 Protorioris

save a flat export data file as an excel file

C676228 17 July 2008 11:27:59
 Hi all,

I have a question for you.

I have a .csv file which has many lines of data.
Each line has many data fields which are delimited by ",".
Now I need to extract part of data from this file but save it as an excel
file.

The data in this excel file will be imported into an Access database. The
reason I have to save it into an excel file is Access program only accept
excel data file, but not flat text file.

Can you tell me how to save extracted data into an excel file?

Thanks.
--
Betty
Add comment
Steven Cheng 17 July 2008 11:27:59 [ permanent link ]
 Hi Betty,

From your description, you have an existing CSV file and you want to
extract some part of the CSV file out and export them into excel file,
correct?

Are you wantting to do it programmtically or just want to do such an
transformation and not necessary to use code? Based on my experience,

#SQL Server 2005 C Integration Services
http://technet.micr­osoft.com/en-us/sqls­erver/bb671392.aspx

#How to import an Excel file into SQL Server 2005 using Integration Services
http://www.buildera­u.com.au/program/sql­server/soa/How-to-im­port-an-Excel-fil
e-into-SQL-Server-2­005-using-Integratio­n-Services/0,3390284­55,339285948,00.h
tm

http://www.mssqltip­s.com/tip.asp?tip=12­02

If this need to be done programmtically, a common approach is read the csv
file via OLD db provider(jet engine) and access the data like a database
table. However, I think it maybe a bit hard to export it exactly as excel
format, btw, excel can directly convert csv format, will it work for your
case.

#How To Open Delimited Text Files Using the Jet Provider's Text IIsam
http://support.micr­osoft.com/default.as­px?scid=http://suppo­rt.microsoft.com:
80/support/kb/artic­les/Q262/5/37.ASP&No­WebContent=1&NoWebCo­ntent=1

#Using OleDb to import text files (tab, csv, custom)
http://www.codeproj­ect.com/KB/cs/UsingJ­etForImport.aspx

Also, are you going to do this converting in ASP web page? If not, for
normal desktop applicatin, we can use excel automation object model to
create excel worksheet:

http://support.micr­osoft.com/kb/302096

http://support.micr­osoft.com/kb/302094

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead


Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
msdnmg@microsoft.co­m.

===================­====================­===========
Get notification to my posts through email? Please refer to
http://msdn.microso­ft.com/subscriptions­/managednewsgroups/d­efault.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microso­ft.com/subscriptions­/support/default.asp­x.
===================­====================­===========
This posting is provided "AS IS" with no warranties, and confers no rights.
-------------------­-
From: =?Utf-8?B?YzY3NjIyO­A==?= <betty@newsgroup.no­spam>
Subject: save a flat export data file as an excel file
Date: Wed, 16 Jul 2008 20:24:01 -0700

Hi all,
I have a question for you.
I have a .csv file which has many lines of data.
Each line has many data fields which are delimited by ",".
Now I need to extract part of data from this file but save it as an excel
file.
The data in this excel file will be imported into an Access database. The
reason I have to save it into an excel file is Access program only accept
excel data file, but not flat text file.
Can you tell me how to save extracted data into an excel file?
Thanks.
--
Betty

Add comment
 

Add new comment

As:
Login:  Password:  
 
 
  
 
Пожалуйста, относитесь к собеседникам уважительно, не используйте нецензурные слова, не злоупотребляйте заглавными буквами, не публикуйте рекламу и объявления о купле/продаже, а также материалы нарушающие сетевой этикет или УК РФ.

QAIX > ASP web-programming > save a flat export data file as an excel file 17 July 2008 11:27:59
see also:
[JBoss Portal] - Problem starting…
[JBoss Seam] - Seam generated Code…
[JBoss Portal] - LDAP and portal…
пройди тесты:
see also:
Free Download - Clone2Go Free Audio…
How to rip DVD and convert video to…
Create your own custom Ipod and Iphones…
  Copyright © 2001—2008 QAIX
Idea: Miсhael Monashev
Помощь и задать вопросы можно в сообществе support.qaix.com.
Сообщения об ошибках оставляем в сообществе bugs.qaix.com.
Предложения и комментарии пишем в сообществе suggest.qaix.com.
Информация для родителей.
Write us at:
If you would like to report an abuse of our service, such as a spam message, please .