Web Design and Development Forums

Data From Excel

This is a discussion on "Data From Excel" within the File Based Storage and Others section. This forum, and the thread "Data From Excel are both part of the Databases category.

Old Jan 21st, 2008, 10:26   #1 (permalink)
New Member
 
Join Date: Aug 2007
Location: india
Posts: 6
Data From Excel
i am getting data from sql with OLEDB connection.
in my excel worksheet i have one column name like "EST."
when i write query like "Select [Est.] from table1" its giving error.
how to access column with "." in column name.

Thanks in advance.
akshitshah is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Old Jan 23rd, 2008, 12:41   #2 (permalink)
Moderator
 
spinal007's Avatar
 
Join Date: Mar 2004
Location: Good Ol'London
Age: 22
Posts: 1,609
Blog Entries: 1
Send a message via ICQ to spinal007 Send a message via MSN to spinal007 Send a message via Yahoo to spinal007 Send a message via Skype™ to spinal007
Re: Data From Excel
Quote:
its giving error
WHAT error? Does it show a message?
__________________
Diego - SEO Consultant London (My Blog | Fight Me)
jQuery: Star Rating - Multiple File Upload - FCKEditor/Codepress
 Before we work on artificial intelligence why don't we do something about natural stupidity?
spinal007 is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Old Jan 24th, 2008, 06:28   #3 (permalink)
Most Reputable Member
 
Join Date: Feb 2004
Location: Borneo
Age: 27
Posts: 1,566
Blog Entries: 2
Send a message via Yahoo to Monie
Re: Data From Excel
When problems like this occur, we are relying on the error message that were produced by the code to debug the problem.

Why named your column as EST with the dot after it? Any special purpose?
__________________
Monie is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply

« Help with install | upload, Store and get image »
Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
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
Anyone know much about Excel AdRock Webforumz Cafe 8 Sep 29th, 2007 19:58
Flash and Excel natepen Flash & Multimedia Forum 1 May 21st, 2007 15:56
Excel Thru Recovery Chase42304 Graphics Forum 3 Nov 27th, 2006 14:21
excel issue tuggers File Based Storage and Others 2 Jan 31st, 2006 16:26
Excel to ASP... courtjester ASP Forum 14 Sep 27th, 2004 20:44



Latest Updates

All Points SEO Security Advisory - CHECK YOUR SITE NOW!

Creative Coding :: February 2008
Webforumz is sponsored by: WESH UK Web Hosting
All times are GMT. The time now is 06:05.

Sleep Study Scoring :: Free Bet :: Website Templates :: Online Betting :: Bookmakers :: Funny Quotes :: Internet Recruitment Software :: Microsoft CRM Experts :: Online Casino :: Decorated Christmas Trees :: Midwife Forums :: Football Betting :: Ecommerce Software :: Web Hosting :: Football Stats :: Dry Cleaning Collection :: xtreme wales - extreme clothing :: Apuestas :: Sharepoint Consultants :: Website Optimisation :: Office Clearance London :: Sharepoint Experts :: Sports Betting :: Casino :: Website Templates :: Web Design Development India :: Online Gambling

Powered by: vBulletin Version 3.7, Copyright ©2000 - 2008, Jelsoft Enterprises Limited.
© 2003-2008 Webforumz.com : All Rights Reserved
Search Engine Friendly URLs by vBSEO 3.2.0 RC6


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59