Weller
Sent: Tuesday, November 08, 2011 2:31 PM
To: profoxt...@leafe.com
Subject: RE: [NF] MS Access question on APPEND-like functionality
I started to try and write a system in Access and gave it up after a short
while - I hate Access. Personal feelings aside :-) - can you connect to the
MDBs
On Tue, Nov 8, 2011 at 12:51 PM, Jarvis, Matthew wrote:
> Since it's been slow, at least this will be something to talk about...
> First of all - Access TOTALLY SUCKS in case you didn't know
>
>
>
> I am trying to pull together data from like-named tables that exist in
> separate MDB files.
>
While pulling into VFP might be fun (& fast!), there are a some gotchas like
weird column names in Access getting munged via ODBC. In theory, you should be
able to use a SELECT ... UNION to get one big table/cursor which could then be
dumped into the current what you want or maybe even do one DB
On 11/8/2011 2:35 PM, Jarvis, Matthew wrote:
> If I could do this in VFP I'd a) be done by now and b) drink a lot less
> than I do...
>
> Anymore I'm a lurker - for the most part haven't done VFP in several
> years...
"Use the Force, Lukeuse VFP again!"
--
Mike Babcock, MCP
MB Software Sol
On 11/8/2011 2:27 PM, Dan Covill wrote:
> On 11/08/11 11:13, MB Software Solutions, LLC wrote:
>> A quick thought: make remote views, grab all the data in, then combine
>> them into one large mess, er, uh, I mean database. If the output must
>> be an Access database, you can then use a utility or
>
> What he said. Manipulate it in VFP, then stuff it back in Access.
>
If I could do this in VFP I'd a) be done by now and b) drink a lot less
than I do...
Anymore I'm a lurker - for the most part haven't done VFP in several
years...
Thanks,
Matthew Jarvis || Business Systems Analyst
IT D
I started to try and write a system in Access and gave it up after a short
while - I hate Access. Personal feelings aside :-) - can you connect to the
MDBs with ODBC? Or possibly export to Excel and do your manipulation in
Excel then re-import? Excel 2010 has a much higher limit that the 64k lim
On 11/08/11 11:13, MB Software Solutions, LLC wrote:
> A quick thought: make remote views, grab all the data in, then combine
> them into one large mess, er, uh, I mean database. If the output must
> be an Access database, you can then use a utility or SPT to write the
> clusterbang back to Acces
On 11/8/2011 1:51 PM, Jarvis, Matthew wrote:
> Since it's been slow, at least this will be something to talk about...
> First of all - Access TOTALLY SUCKS in case you didn't know
>
>
>
> I am trying to pull together data from like-named tables that exist in
> separate MDB files.
>
>
>
> For ex
9 matches
Mail list logo
