SQL and Table names with dots 
Author Message
 SQL and Table names with dots

I am developing an application which accesses Foxpro (*.dbf) files.  I can
open these tables directly using the Jet engine and the standard syntax.

My problem is that my table names contain a 'dot'.  ie. employee.dbf,
jobcodes.dbf, etc.  When I try to use an SQL Statement to retreive some
data, the Jet engine sees the dots as a seperator for 'Tablename.Field'.

The documentation states to use square brackets ([ ]) if the tablename
contains punctuation, but this is not working.  It still seems to 'see' the

I was unable to find any help on commands that would allow an 'alias' for my

As a workaround, I attatch the tables to a Access Database, where I can
define an attachment name and then everything is ok.

Does anyone know how to accomplish this using the *.dbf files directly?

Thanks in advance.
Gene Oshinsky
POSNET Computers

'Remove NOJUNK to reply'

Mon, 04 Sep 2000 03:00:00 GMT
 [ 1 post ] 

 Relevant Pages 

1. VS DOT NET MSDE SQL engine, ad hoc updates to system tables

2. Database name with dot(.)

3. bcp utility cannot stand Databases names with dots

4. column name with a . (dot)

5. PSQL 7: Dots in field names

6. how to get column names given table name through sql query

7. Passing table name, field name as parameters in dynamic SQL

8. SQL Server forcing the owner name to be entered all of a sudden in table name

9. Accessing another user's table without qualifying table name with the owner-name

10. system tables - link SP name and Table Name?

11. dynamic sql include table data type as table name

12. Attaching SQL Server 7.0 tables in MS Access with long table names

Powered by phpBB® Forum Software