Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

column name

Status
Not open for further replies.
Jeff98

Jeff98

Programmer
Oct 19, 2006
14
US
I import excel to access and get filed name with space in between. ("account number" for example). How to let access sql handle filed name like that?

THX
 
Sort by date Sort by votes
SELECT [!][[/!]account number[!]][/!] ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

btamsgn
  • Locked
  • Question
How to arrange the values in column heading based on column STT
Replies
10
Views
2K
combo
combo
Swi
  • Locked
  • Question
Jet Sql Statement - Select Distinct Multiple Columns 1
Replies
4
Views
831
Swi
Swi
rudolfelizabeth
  • Locked
  • Question
day function in ms access doesn't return the day name and there isn't a function date name
Replies
3
Views
382
Andrzejek
Andrzejek
teach314
  • Locked
  • Question
Filling a column with 'missing' values 1
Replies
5
Views
202
dhookom
dhookom
uwrijc
  • Locked
  • Question
Using a separate sort column works in query, but doesn't transfer to pivot table or chart view 1
Replies
5
Views
202
TheresAlwaysAWay
TheresAlwaysAWay

Part and Inventory Search

Sponsor

Back
Top