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