Re: Need help changing a excel *** to a access DB, NOT Linked

From: Jeff Boyce (JeffBoyce_IF_at_msn.com-DISCARD_HYPHEN_TO_END)
Date: 05/15/04 

Date: Fri, 14 May 2004 17:52:30 -0700

Thanks, Armen.

When I thought more about it, I realized Access doesn't have "parsing"
queries! But I use queries to "parse"... <g>

Jeff Boyce
<Access MVP>

"Armen Stein" <Armen_RemoveThis_@RemoveThis_JStreetTech.com> wrote in
message news:MPG.1b0e7f2f7883c95d989709@news.microsoft.com...
> In article <Oxq6aoaOEHA.3348@TK2MSFTNGP09.phx.gbl>,
> JeffBoyce_IF@msn.com-DISCARD_HYPHEN_TO_END says...
> > Greg
> >
> > "Linked" means, well, linked. Instead of using "Link..." when you "Get
> > External Data", try using "Import..."
> >
> > Note: if any of your Excel data is ambiguous (as to type), you'll get
what
> > Access decides to call it for field types. If this happens, you can
still
> > create your own table definition in Access, then do parsing queries from
> > your imported/linked table into the one you defined.
> >
> >
>
> A minor clarification on Jeff's response:
>
> The "parsing" queries Jeff is referring to are actually Append queries
> in Access. These can be used to copy data from one table to another.
>
> --
> Armen Stein
> Access 2003 VBA Programmer's Reference
> http://www.amazon.com/exec/obidos/ASIN/0764559036/jstreettech-20
> J Street Technology, Inc.
> Armen _@_ JStreetTech _._ com