Groups > comp.lang.basic.visual.misc > #530

Re: Getting inside an .accdb file

From	ralph <nt_consulting64@yahoo.net>
Newsgroups	comp.lang.basic.visual.misc
Subject	Re: Getting inside an .accdb file
Date	2011-11-23 15:10 -0600
Organization	Aioe.org NNTP Server
Message-ID	<1dnqc75sbebe64n81tb42npjl4kphjejv9@4ax.com> (permalink)
References	(2 earlier) <VA.00003677.046046c6@ukrm.net> <s9bdc7lcikf52o1nnj6gq45bep3emoh36e@4ax.com> <VA.00003684.09ae4636@ukrm.net> <0oblc7pfk10v98r7ltis6332007vqcn43o@4ax.com> <VA.00003695.1fecf270@ukrm.net>

Show all headers | View raw

On Wed, 23 Nov 2011 18:10:00 -0000, R C Nesbit <spam@ukrm.net> wrote:

>
>But we also use other RDBMS's, MySQL, SQL-Server etc. and migrating data from 
>an Access file with spaces all over the place is a pain in the bum, to be 
>honest.

Yes it is.

Just in case ... you do know you can use square backets to delimit
Field names and keywords in queries with SQL-Server (by default double
quotes, but can be configured to use brackets) and Jet formatted
databases.

MYSQL uses the grave accent, ASCII 96. (Also called the backtick, a
backquote, or simply a tick.)

-ralph

Back to comp.lang.basic.visual.misc | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Getting inside an .accdb file R C Nesbit <spam@ukrm.net> - 2011-11-17 09:48 +0000
  Re: Getting inside an .accdb file H-Man <Spam@bites.fs> - 2011-11-17 14:37 -0700
    Re: Getting inside an .accdb file H-Man <Spam@bites.fs> - 2011-11-17 16:23 -0700
      Re: Getting inside an .accdb file R C Nesbit <spam@ukrm.net> - 2011-11-18 09:46 +0000
        Re: Getting inside an .accdb file Tony Toews <ttoews@telusplanet.net> - 2011-11-18 12:10 -0700
  Re: Getting inside an .accdb file Tony Toews <ttoews@telusplanet.net> - 2011-11-17 16:08 -0700
    Re: Getting inside an .accdb file R C Nesbit <spam@ukrm.net> - 2011-11-18 09:46 +0000
      Re: Getting inside an .accdb file Tony Toews <ttoews@telusplanet.net> - 2011-11-18 12:09 -0700
        Re: Getting inside an .accdb file R C Nesbit <spam@ukrm.net> - 2011-11-19 10:29 +0000
          Re: Getting inside an .accdb file Tony Toews <ttoews@telusplanet.net> - 2011-11-21 13:05 -0700
            Re: Getting inside an .accdb file R C Nesbit <spam@ukrm.net> - 2011-11-23 18:10 +0000
              Re: Getting inside an .accdb file ralph <nt_consulting64@yahoo.net> - 2011-11-23 15:10 -0600
              Re: Getting inside an .accdb file Tony Toews <ttoews@telusplanet.net> - 2011-11-24 17:12 -0700
        Re: Getting inside an .accdb file Jason Keats <jkeats@melbpcDeleteThis.org.au> - 2011-11-19 22:23 +1100
          Re: Getting inside an .accdb file R C Nesbit <spam@ukrm.net> - 2011-11-20 12:30 +0000

csiph-web