Also I forgot to add that what I want to do is make sure "roll number" is visible in all 3 tables when I use the table analyzer.
Any suggestions?
Thanks,
Mark
As what I want to do is make sure "roll number" is visible in all 3 tables when i use the
--- In MS_Access_Professionals@yahoogroups.com, "Mark" <mmirrlees@...> wrote:
>
> Hi thanks for your help as it seemed to do the trick. Now I do have a follow up question...how can I "normalize it" the data into 3 tables. As when I use the analyze table option it seems to make several tables...the primary key should be rollnumber.
>
> Mark
>
> --- In MS_Access_Professionals@yahoogroups.com, "Graham Mandeno" <graham@> wrote:
> >
> > Hi Mark
> >
> > First, I apologise for all the BBCode tags that were sprinkled through my
> > first answer. I had not yet had my second coffee for the morning and I
> > thought I was posting to a different forum :-/
> >
> > More importantly, it appears that your file is NOT fixed width, but is
> > actually variable width with "%" as a delimiter.
> >
> > In the import wizard, select "Delimited" and click Next. Then select
> > "Other" as the delimiter and type % in the adjacent box. Also, select the
> > "First row contains field names" option, then click Next.
> >
> > You will then need to change the data types of some of the fields.
> > RollNumber should be changed to Text (because the 19-digit numbers are too
> > long for a numeric data type). You may also want to change StreetNumber
> > (Integer or Text?), and AssessedValue (Currency?).
> >
> > Then all the records should import without errors.
> >
> > Best wishes,
> > Graham
> >
> > > From: MS_Access_Professionals@yahoogroups.com
> > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Mark
> > > Sent: Tuesday, 15 May 2012 08:44
> > > To: MS_Access_Professionals@yahoogroups.com
> > > Subject: Re: [MS_AccessPros] Importing text file into Access 2007 problems
> > >
> > >
> > > Hi there,
> > >
> > > Also I put a file in the files section called "Text file of import
> > problem" under the 2_AssistanceNeeded folder to show what i'm talking about.
> > >
> > > Thanks again,
> > > Mark
> > >
> > > --- In MS_Access_Professionals@yahoogroups.com, "Graham Mandeno"
> > <graham@> wrote:
> > > >
> > > > Hello Mark
> > > >
> > > > You say you: "[i]...selected 'fixed width format' since that's what
> > Access
> > > > believes it is[/i]
> > > >
> > > > [b]Is it [i]actually[/i] fixed width format?[/b] You should be the one
> > to
> > > > make that call, not Access.
> > > >
> > > > It seems strange that the message pops up before you have even defined
> > the
> > > > number or lengths of the fields. It almost sounds as if the
> > [i]record[/i],
> > > > not the [i]field[/i] is too long.
> > > >
> > > > [b]Are you sure there are actually line breaks between the records?[/b]
> > > > (Open the textfile in Notepad and make sure each record starts on a new
> > > > line)
> > > >
> > > > Finally, [b]can you identify anything that is different between this
> > import
> > > > and the others you have done successfully?[/b]
> > > >
> > > > Best wishes,
> > > > Graham
> >
>
Tidak ada komentar:
Posting Komentar