Can I hide a part of the text by a "More..." link?
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: 
Car web design, motorbike…
If you are looking for Car website design, Auto web design, bike web design, or anything similar our…

The Best Video Converter-a…
iOrgSoft Inc. has released the powerful Video Converter - iOrgSoft Video Converter 1.6.0, the latest…

Photo DVD Maker New Website…
AnvSoft Inc., the multimedia software developer, unveils a new website…

How to rip DVD movie, convert…
It is no doubt that PSP is an excellent game player. However, it is not playing games all the time; you…

World’s Most Unusual Christmas…
This Christmas, don’t go with that ho-hum, run-of-the-tree-far­­m tree your family always gets…

Facebook account cracker
facebook account cracker (50 GBP) Before you're told what this tool does, it's worth noting that…

BlackBerry Storm review…
As BlackBerry fans, you can’t miss the BlackBerry Storm. At Nov 6th, 2008, the word on the street is…

Review on Any DVD Cloner
Have you ever had a DVD Movie collection broken or lost? Have you ever wanted to backup movies but…

All recruitment agencys come…
What is RCCSS? RCCSS is a new unique peice of software which will scan millions of major sites and…

Problem when new cartridge(s)…
http://www.fdgtoner.­­com the munufacturer and supplier of toner cartridges and inkjet…

  They have birthday today: 
akram mellice
Daffy little vampire
  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: 
Converting number to percentage…
Hi Im Leo I want to convert a number to percentage, is there any built-in function for this? Thanks

RE: Jason Gilbert, CTO of…
I have been searching for an old friend with the same name and age - Jason Gilbert. I am upset that…

Problem with Stored Procedure
I have this in my stored procedure: @PageID INT, @VersionID INT UPDATE Pages SET…

ASP Access Recordset Paging
Hi all, I have access database file with 2 tables, the tables have the same columns but with different…

problem with javascript in asp…
Hi All, I have a neat little script that calculates price based on quantity without refreshing the…
  Recent forum topics: 
Problem with uploader
I'm trying to make a CGI script to upload files remotely onto my server, to get around my uni blocking…

what is the best / latest .CGI…
what is the best / latest .CGI to handle safe form parsing? Lou

neopets hacking
for all of ya'll who play neopet this is a great way to get rich quick okay see this link at the bottom…

[svn:perl6-synopsis] r14606…
Author: larry Date: Mon Nov 17 17:12:39 2008 New Revision: 14606 Modified…
  Recent forum comments:
RE: [JCA/JBoss] - getOutputStream()…
Put Your Java Code in Servlet. It will work fine Try to avoid scriplet in jsp

RE: RE: Please Help Advanse Search…
Old Pedant wrote: *******************­ ... unless navigation in the recordset has occurred, or…

RE: CDO.dll or cdosys.dll
Steven, Thank you. I will be using the CDOSYS.dll. Even thought my question seems basic your answers…

RE: ASP Page Counter
Anthony Jones wrote on 20 aug 2008 in microsoft.public.in­etserver.asp.general­…

RE: how to retrieve CheckBox value…
magix wrote on 21 aug 2008 in microsoft.public.in­etserver.asp.general­: I think…

RE: how to retrieve CheckBox value…
Evertjan. wrote: More like .Count…

RE: how to retrieve CheckBox value…
Dave Anderson wrote on 21 aug 2008 in microsoft.public.in­etserver.asp.general­…

RE: how to retrieve CheckBox value…
"magix" wrote: Other answers right, but more complex than needed. Just do this: <%…

RE: how to retrieve CheckBox value…
Old Pedant wrote: Perhaps not, but I would suggest you do so. I'm surprised a pedant would advise…

RE: how to retrieve CheckBox value…
"Bob Barrows " wrote: LOL! But it *IS* precise...if you know what you are doing…
  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:
Printing in one line like in Java or…
Make hyperlink invisible?
пройди тесты:
see also:
Start calling card business under your…
Hosted VoIPSwitch+Full Control+All…
  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 .