Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Other Programming > VBScript
|
VBScript For questions and discussions related to VBScript.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VBScript section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #11 (permalink)  
Old February 20th, 2006, 06:24 AM
Authorized User
 
Join Date: Feb 2006
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

solution for this problem is to put 'IMEX=YES' Attribute in connection of oledb.this fetches the data from the excel column as text format.

try it
this will work

Reply With Quote
  #12 (permalink)  
Old July 4th, 2006, 09:11 AM
Registered User
 
Join Date: Jun 2003
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to g000we Send a message via Yahoo to g000we
Default

If anyone is trying to put a number into a cell of a CSV file with a preceding 0 or zero, then add a preceding "'" character e.g."value1","value2","'001234". Excel grumbles but Customers are happy!

Jesus == Way == Truth == Life == Love == God
Reply With Quote
  #13 (permalink)  
Old June 8th, 2007, 06:02 AM
Registered User
 
Join Date: Jun 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Ajimi
  Can u please Post me the asp code for
"asp page that reads any CSV file, retrieves the data and displays on the page" no need to send to sql. just display.
My email id is [email protected]
And its urgent
Thanks in advance
Reply With Quote
  #14 (permalink)  
Old March 19th, 2008, 09:59 AM
Registered User
 
Join Date: Mar 2008
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I ma getting same problem which describe below


Hello everyone, I'm having the some problems parsing CSV and Excel files. I can retrieve a numerical data like 5 digit zip code but cant retrieve a string data which is 9 digit zip code with "-" between them in a same Zip code field. Any one has an idea about this problem?

PLEASE SEND ME C#.NET code to resolve it ...It is very critical

Send me at [email protected]

Please be needful

Thanks in advance



Reply With Quote





Similar Threads
Thread Thread Starter Forum Replies Last Post
Import CSV files to Database in C# prasanna.nadgir C# 2 September 4th, 2007 11:03 AM
how to import data from excel,csv into sql server therisingsun ASP.NET 1.0 and 1.1 Basics 2 October 1st, 2005 12:17 AM
How to retrieve specific string zorzos Excel VBA 1 August 25th, 2004 05:41 AM
Querying .csv files aspiring_db_fundu Excel VBA 4 February 25th, 2004 01:01 PM
Retrieve data from local Access files aslyon ADO.NET 2 October 31st, 2003 08:52 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.