Senin, 14 Mei 2012

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