Message from discussion Convert first record only
Received: by 10.180.105.198 with SMTP id go6mr1664009wib.2.1352352922365;
Wed, 07 Nov 2012 21:35:22 -0800 (PST)
From: "David Hare-Scott" <sec...@nospam.com>
Subject: Re: Convert first record only
Date: Fri, 2 Nov 2012 16:36:17 +1100
References: <firstname.lastname@example.org> <email@example.com> <firstname.lastname@example.org> <email@example.com> <firstname.lastname@example.org> <email@example.com> <firstname.lastname@example.org> <email@example.com> <firstname.lastname@example.org> <email@example.com> <firstname.lastname@example.org> <email@example.com>
X-Trace: news.albasani.net GRDt03csGjVbOTEsdk1cud6ct1H3yjbjSLNKlcNBPIE0mlTVQEzJG4+Buwzml3sLIro6veSsszIT1AZ1KIJf2aN2rVHTSZCQVHYLrpbD/w1tJTaY/xswjp2NM8qPSnaM
NNTP-Posting-Date: Fri, 2 Nov 2012 05:36:04 +0000 (UTC)
Injection-Info: news.albasani.net; logging-data="Y0f7Qvck8janoZI7ULhfix+gSnVApJd6ccp0QRAIqLTdq1mHj/4dI0ltdRaR5kRMrgjDkVY6NiwK0CCyQ74xQvoCm/+lYWOH/v+yx5wR408RgUa0qezzExUTIq9Wre6F"; mail-complaints-to="ab...@albasani.net"
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.6157
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
> On Thursday, November 1, 2012 10:05:13 PM UTC-7, guu...@gmail.com
>> On Thursday, November 1, 2012 5:42:10 PM UTC-7, David Hare-Scott
>> wrote: > gu...@gmail.com wrote: > On Saturday, October 27, 2012
>> 10:14:24 PM UTC-7, David Hare-Scott > wrote: >>> Where do I draw the
>> line before I can say Access is not up to job >>> and > what ETL
>> tools would you then suggest? 500K records? 1M >>> records? > 500MB
>> accdb file size? What exactly are you going to do >>> with this
>> data? Why use Access instead of oracle? Why are you >>> importing it
>> instead of linking to the oracle database? Access is >>> limited to
>> 2gig in a native database but you can link to other >>> database
>> formats and you can use many back-ends in native format >>> each
>> holding 2 gig. Until we know what you are up to there is no >>> way
>> to say where you will reach a limit in Access. > > Reply: >
>> Extracted and transferred data originates from nightly batch >
>> production processes. The data must be loaded into an easy to use >
>> readily available no extra cost app (in this case Access 2010) by a
>> > clerical worker (aka not too techie analyst)for generating daily >
>> summary pretty-print exception reports before 6 am for mid-level >
>> management who will then assign it to hunter-killer groups :-). The
>> > analyst does not have access or permission to interact with unix >
>> based character based sql legacy app which uses Oracle as the >
>> back-end database. The 'mission-critical' legacy app and Oracle >
>> back-end is hosted in a genormous data-center in another state. >
>> Getting them to make changes requires change management involvement,
>> > cost justification, approvals, etc. Getting access permissions >
>> requires several signatures too. Unix and sql skills required also.
>> > Not worth the effort or multi-divisional exposure. Hence Access. I
>> would be inclined to put each extract into a separate Access
>> database, you can generate these programatically based on the date,
>> name of the import file, etc. The import process seems to be under
>> control so it comes down to the performance of your reports. I would
>> experiment with indexing the fields that are used for joining and
>> restriction as there will be a trade off between the cost of running
>> queries on unindexed tables and doing the indexing. Obviously if
>> there are many reports run on the same data or each may be run
>> several times then indexing once at the start is likely to be
>> cheaper. So far I haven't seen anything that Access can't do,
>> whether it can do it quick enough for your liking is another matter.
>> If it is any consolation I have had an Access table with over 2
>> million records and searches on indexed fields took a fraction of a
>> second. David Good to know.
>>What was the size of your .accdb file?
It was an MDB and IIRC about 400M
>> Thank you very much.
> Forgot to ask. Can I convert a csv file to an accdb file from the
> Windows 7 command line?
Out of the Windows 7 box no, but you can run Access with a specified startup
or command line arguments.
>Can I launch an Access macro from the command
> line? Thanks again.
Yes. You can also set up an icon on the desktop that launches Access and
opens the specified database with specified arguments. If it is only ever
going to do one function you can also have the database start the process
you want whenever it opens and so avoid command line args. And yes you can
defeat that auto startup if you want to work on the databse instead of run
the process (or just have two different icons).