Selasa, 15 Mei 2012

Re: [MS_AccessPros] Importing text file into Access 2007 problems

 

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
>

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar