Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access 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
 
Old January 24th, 2005, 03:48 AM
Registered User
 
Join Date: Dec 2004
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default column name with space in access

hai everybody,

in my table there is a space in column names. how i can retrieve that field using select query. I don't want to put select * from tablename. i want to retrieve like this select column1,column2 from table name. help me

thanks in advance

Kalyanaraman Narayanan
 
Old January 24th, 2005, 04:13 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 120
Thanks: 0
Thanked 0 Times in 0 Posts
Default

As you've discovered, spaces in names cause problems.

The ideal solution would be to remove them! Assuming you've gone too far to do this without loads of work, just wrap the field names in square brackets.

Code:
SELECT [table 1].[field 1]
FROM [table 1]

Brian Skelton
Braxis Computer Services Ltd.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Space in my database table Access cannielynn0312 ASP.NET 1.0 and 1.1 Basics 4 December 27th, 2007 06:02 AM
Access to phisical addreses from user space somevlad Linux 0 June 15th, 2006 08:03 PM
Access Column Attributes ~Bean~ ADO.NET 0 November 16th, 2005 09:21 AM
Refer To Access Table's Column Name ritag Access ASP 3 June 24th, 2004 09:30 AM





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