Select * from table??!!

SELECT [Data Table].*
FROM [Data Table];

If the table name contains spaces enclose it in [] as shown above.

Regards,

Matt



"Kaczala" <ghuber.DeleteThis@poczta.onet.pl> wrote in message
news:c95gok$f83$1@opal.icpnet.pl...
 > Hi
 > I have i smple problem
 > I want to perform a query that containst path as table name.
 > Problem is when the path contains spaces
 >
 > Example:
 >
 > SELECT * FROM C:\TEMP\MyDatabase.dbf 'OK
 > SELECT * FROM C:\Program Files\MyDatabase.dbf 'ERROR (space in table
 > name)
 > SELECT * FROM "C:\Program Files\MyDatabase.dbf " 'ERROR
 > SELECT * FROM 'C:\Program Files\MyDatabase.dbf' 'ERROR
 >
 > How can I correct this to start working.
 > Thanks in advice.
 > Kaczala
 >
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Select * from table??!! 

I am familiar with this site but I dont think I can find solution there.


<font color=purple> > <a style='text-decoration: underline;' href="http://www.connectionstrings.com</font" target="_blank">www.connectionstrings.com</font</a>>
 >
 > --
 >
 > Regards
 >
 > Steven Burn<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Select * from table??!! 

It still doesnt work.

SELECT * FROM [C:\Program Files\MyDatabase.dbf ] 'ERROR

SELECT [C:\Program Files\MyDatabase.dbf ].* FROM [C:\Program
Files\MyDatabase.dbf ] 'ERROR

 > SELECT [Data Table].*
 > FROM [Data Table];
 >
 > If the table name contains spaces enclose it in [] as shown above.
 >
 > Regards,
 >
 > Matt<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Select * from table??!! 

Dim strDB As String, strSQL As String
strDB = "C:\Program Files\MyDatabase.dbf"

Set rst = CreateObject("ADODB.Recordset")
strSQL = "Select * From tblTable_Name"
rst.Open strSQL, strDB, adOpenStatic, adLockpessimistic

HTH

--

Regards

Steven Burn
Ur I.T. Mate Group
<a style='text-decoration: underline;' href="http://www.it-mate.co.uk" target="_blank">www.it-mate.co.uk</a>

Keeping it FREE!


"Kaczala" <ghuber.DeleteThis@poczta.onet.pl> wrote in message
news:c95p79$q7o$1@opal.icpnet.pl...
 > It still doesnt work.
 >
 > SELECT * FROM [C:\Program Files\MyDatabase.dbf ] 'ERROR
 >
 > SELECT [C:\Program Files\MyDatabase.dbf ].* FROM [C:\Program
 > Files\MyDatabase.dbf ] 'ERROR
 >
  > > SELECT [Data Table].*
  > > FROM [Data Table];
  > >
  > > If the table name contains spaces enclose it in [] as shown above.
  > >
  > > Regards,
  > >
  > > Matt
 >
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Select * from table??!! 

"Kaczala" <ghuber RemoveThis @poczta.onet.pl> wrote in message
news:c95p79$q7o$1@opal.icpnet.pl
 > It still doesnt work.
 >
 > SELECT * FROM [C:\Program Files\MyDatabase.dbf ] 'ERROR

are you trying to read data from a database without opening it first? You
need to establish a connection to MyDatabase.dbf and then do a select from
one or more tables.



--
Reply to the group so all can participate
VB.Net... just say "No"<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Select * from table??!! 

Did u try "SELECT * FROM C:\Progra~1\MyDatabase.dbf"? "Progra~1" is the
directory name under DOS prompt.



"Bob Butler" <tiredofit DeleteThis @nospam.com> wrote in message
news:#zcRklDREHA.2404@TK2MSFTNGP09.phx.gbl...
 > "Kaczala" <ghuber DeleteThis @poczta.onet.pl> wrote in message
 > news:c95p79$q7o$1@opal.icpnet.pl
  > > It still doesnt work.
  > >
  > > SELECT * FROM [C:\Program Files\MyDatabase.dbf ] 'ERROR
 >
 > are you trying to read data from a database without opening it first? You
 > need to establish a connection to MyDatabase.dbf and then do a select from
 > one or more tables.
 >
 >
 >
 > --
 > Reply to the group so all can participate
 > VB.Net... just say "No"
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Select * from table??!! 

For DBF's the folder is the 'database' name, and the DBF file (no extension) is the table. Spaces
in the path are immaterial and do not affect the usage since the connection string is delimited by
'=' and ';' for parameter and value pairs.

Dim pobjConnection
Dim pobjRS
Dim pstrDatabase
Dim pstrConnectionString
pstrDatabase = "C:\Program Files\MyFolder"
pstrConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & pstrDatabase & ";" & _
"Extended Properties=dBASE IV;" & _
"User ID=Admin;" & _
"Password="

'Open connection to the folder.
Set pobjConnection = CreateObject("ADODB.Connection")
pobjConnection.Open pstrConnectionString

'Get the recordset
Set pobjRS = CreateObject("ADODB.Recordset")
pobjRS.Open "SELECT * FROM DBFNAME", pobjConnection

Hope this helps,

Chris.

"Kaczala" <ghuber.TakeThisOut@poczta.onet.pl> wrote in message news:c95gok$f83$1@opal.icpnet.pl...
Hi
I have i smple problem
I want to perform a query that containst path as table name.
Problem is when the path contains spaces

Example:

SELECT * FROM C:\TEMP\MyDatabase.dbf 'OK
SELECT * FROM C:\Program Files\MyDatabase.dbf 'ERROR (space in table
name)
SELECT * FROM "C:\Program Files\MyDatabase.dbf " 'ERROR
SELECT * FROM 'C:\Program Files\MyDatabase.dbf' 'ERROR

How can I correct this to start working.
Thanks in advice.
Kaczala
 >> Stay informed about: Select * from table??!! 

Try

SELECT * from "C:\[program files]\mydadabase.dbf"

That's what Matt meant.

Argusy

Kaczala wrote:
 > It still doesnt work.
 >
 > SELECT * FROM [C:\Program Files\MyDatabase.dbf ] 'ERROR
 >
 > SELECT [C:\Program Files\MyDatabase.dbf ].* FROM [C:\Program
 > Files\MyDatabase.dbf ] 'ERROR
 >
 >
  >>SELECT [Data Table].*
  >>FROM [Data Table];
  >>
  >>If the table name contains spaces enclose it in [] as shown above.
  >>
  >>Regards,
  >>
  >>Matt
 >
 >
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Select * from table??!!