View Single Post
  #5   Report Post  
Posted to microsoft.public.word.docmanagement
CyberTaz CyberTaz is offline
external usenet poster
 
Posts: 1,348
Default can't import fields in Excel having spaces to my Access table

IIRC - In order to append data as a part of the import process the field
names must match *exactly*... The _ and a space are not equivalents.

BTW - what does this have to do with Word?

Regards |:)
Bob Jones
[MVP] Office:Mac



On 9/4/06 4:18 AM, in article
, "neb"
wrote:

e.g.
Excel field: Date Posted
Access field: date_posted
Error 3075 occurs(because of spaces...)

"Jezebel" wrote:

Yes, you can.


"neb" wrote in message
...
I can't import fields in Excel having spaces to my Access table using the
SQL
SELECT...