Microsoft Access Importing Data

Tech-Archive recommends: Speed Up your PC by fixing your registry

I am using a software package that exports into Microsoft Access
2002 (also with Windows XP Professional).

The issue that I am having is that the data is exported into
a "flat file" format. For example the data looks like this:

ID First name Last Name City Charges
01 John Doe Boston $11.20
01 John Doe Boston $99.99
01 John Doe Boston $55.99
02 Jane Smith Houston $11.88
02 Jane Smith Houston $88.99

The data is superhuge. Just imagine screen after screen
with user charges, repeated city names, etc.

The data does not seem to be a good fit (the database file
is about a gigabyte plus). Since the data is not relational,
it takes a long time to run. (I believe the person who set it
up before me clocked it at 2 hours just to run a report.)

Can Access break down the tables into relational ones?
For example, extract the raw data and make a city table
(ex. one time "Boston" shows up, one time "Houston" shows up, etc.) I
would like all the data to link up in a one-to-one or one-to-
many connection on it's own, so I don't have to worry about
data integrity. Human error is a real issue here because of
all the data and one mistake could make reports worthless.

These reports will be likely on a weekly basis, so I would
like this to be as user friendly as possible (since it is going
to be done many times). Automation with macros would also
be a big plus (if you could give ideas how I would go about doing
this).

Any ideas? If you could walk me through step by step, I'd really
appreciate it.

Thanks!



.

Relevant Pages

  • Re: Advice needed for a growing Access 2000 project
    ... However, it turned out that quite a few of those were "leftovers" from previous releases, no longer accessible from anywhere but the database window, and, thus, no longer used. ... But that certainly isn't the _norm_ -- without any 'heroic' measures, there are routine reports of split Access DBs ... Finally, in my opinion, for "Windows apps", that is, individual-user applications, modest-sized multiuser applications, and client-server applications of any size, Dot Net does NOT "help along" any of these issues. ... The post I reference was in reference its self to the MS Access Help file under "Microsoft Access database general specifications" ...
    (comp.databases.ms-access)
  • Re: Images in VBA application
    ... If you are printing the images in reports, to avoid memory leakage, you ... the Access formatting process prior to being spooled to the Printer Driver. ... Memory" error that can popup when printing image intensive reports. ... Microsoft Access MVP ...
    (microsoft.public.access.modulesdaovba)
  • Re: How can I attach several reports to one email message?
    ... I have no idea what tables would look like when sent as attachments ... Then I'd suggest explicitly creating PDF files from the reports. ... Alternatively see Creating PDF files from within Microsoft Access ...
    (microsoft.public.access.reports)
  • Re: Why wont this statement work
    ... that you'll use a word reserved by Access/VB/JET ... ... "fredg" wrote: ... building reports in access for the first time. ... Reserved Words in Microsoft Access' ...
    (microsoft.public.access.reports)
  • Re: Propagating Field Name Changes
    ... Joan Wild ... Microsoft Access MVP ... > list with LASTNAME as the control name. ... >>>However, forms, reports, and modules do not. ...
    (microsoft.public.access.tablesdbdesign)