dbf file name

[Guest]

Hi all,

I got to this problem with dbf file name: if the name is a single word (such
as Category.dbf, mytest.dbf...) then I can import to a temp table from menu
bar and also from VBA code... otherwise I can't (my test.dbf,
TestSpace.dbf)...

Can anyone know what's wrong with this dbf file name? What do I do to make
it work?
Thanks in advance...

 

[OfficeDev18 via AccessMonster.com]

Depends on your usage. Try bracketing the name [my test].[dbf]. if that
doesn't work, try enclosing it in quotes "my test.dbf"

Hope this helps

Sam

 

[Charles E. Vopicka]

i seriously doubt that the DBF drivers have been updated since DOS.
(just a personal observation) so it may still be requiring 8.3 format
names. if you can figure out how to translate the long name to the
equivalent 8.3 that may be your best bet. like Program Files i think is
Progra~1. stuff like that

Hi all,

I got to this problem with dbf file name: if the name is a single word (such
as Category.dbf, mytest.dbf...) then I can import to a temp table from menu
bar and also from VBA code... otherwise I can't (my test.dbf,
TestSpace.dbf)...

Can anyone know what's wrong with this dbf file name? What do I do to make
it work?
Thanks in advance...

--
Charles E. Vopicka's (Chuck) : (e-mail address removed)

Database Management, GIS Specialist and Research Assistant

Forest Biometrics Research Institute
University of Montana - College of Forestry and Conservation
Missoula, MT 59812
United States of America

Phone:
(406)243-4526
(406)243-4264
(406)549-0647 (Home)

HAVE A NICE DAY (-:

"UNLESS" (The Lorax, by Dr. Seuss)

 

[Guest]

Thank Charles & Sam for your reply. I will either try to figure out how to
translate the long name to 8 characters file name by VBA code or have to
manually rename the dbf file to 8chars...

Have a good day...