That's only 22 characters. Unlike Access/Jet, you can start to get into
trouble with ODBC when you have big and long table or index names, but 22
characters wouldn't even bother SQL Server.
(david)
"Paul Clement" <UseAdddressAtEndofMessage@swspectrum.com> wrote in message
news:7st4909as3i17dn0c0ejtkd256s2teoatq@4ax.com...
> On Fri, 30 Apr 2004 00:11:03 -0700, Richard Tang <richard.tang@gawab.com>
wrote:
>
> ¤ Greetings to all..
> ¤
> ¤ I've a simple Qs to VB (6.0) cum ACCESS DB (2000) gurus.
> ¤
> ¤ In VB, can I query a long table name ..E.g "Select * from [big and long
tablename]" ?
> ¤ if no, any alternatives beside rename it.
>
> The syntax looks fine to me.
>
>
> Paul ~~~ pclement@ameritech.net
> Microsoft MVP (Visual Basic)
Re: Ranking difficulty ...TableName as the name for your table -- If you continue to use Name as the ... information about reserved words and characters that should not be used: ... I created a ranking by ranking the scores and named it RANKID.... (microsoft.public.access.queries)
Re: Data checking problem... ... SELECT * FROM tablename where lastname NOT LIKE '%%' ...strange characters or whathaveyou). ... > SQL Server MVP... >> I'm not too keen on creating a plethora of sql tasks to ... (microsoft.public.sqlserver.dts)
Database fields get cut off in Excel ... I've set up a simple query to a Sybase database (select * from tablename) where ... some of the fields contain text strings.... No matter what I've tried (not that I'm ... I get 5 characters and in others 14). ... (microsoft.public.excel.programming)
Re: Text field about 9000 karakters long. ... > Text pointers are used with text/image fields.... > SELECT @PTR=TEXTPTRFROM TableName... >> few characters have to be removed. ... (microsoft.public.sqlserver.server)
Re: International Characters in a merge field ... If it is a plain text file, then Word will typically use ODBC to open the file if ODBC is set up and the text driver is present. ... There may be one or two other settings but I don't remember anything that would affect Word 2000. ... Are there any settings in word that involve importing or special characters that I could check to make sure these are set correctly? ... e.g. it may be possible if you write VBA to get data via OLE DB, stuff it into a Word table and use that as a data source.... (microsoft.public.word.mailmerge.fields)
