Re: Importing into predefined fields

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks - but I am aware of this wizard. I want to import multiple files all
with the same field structure. I wish to avoid having to define up to 80
fields each time I import which is why I asked about pre defining field
lengths.

kind regards

Peter Lawton


"MH" <noway@xxxxxxxxxxx> wrote in message
news:e35blH2TGHA.1160@xxxxxxxxxxxxxxxxxxxxxxx
When you import stuff into Access, you go through a wizard which does all
this for you, what you are doing is importing a fixed width text file.
Give it a go.

MH


"Peter Lawton" <pete_lawton@xxxxxxxxxxx> wrote in message
news:ON5Imv1TGHA.1160@xxxxxxxxxxxxxxxxxxxxxxx
I have a text file I need to import into Access 2002. It is not delimited
however I know the char length for each field. Is there a way I can import
mutliple records into a table with predefined field sizes (e.g. Field 1 -
10 chars, Field 2 - 3 chars, Field 3 - 1 char etc up to 80 fields) so the
correct info drops into the correct slot.



I am not VBA literate



kind regards



Peter Lawton










.

Relevant Pages

  • Re: Search & Replace in multiple files
    ... Nicolas Payre wrote: ... > I'm looking for a command to do some search & replace into multiple files. ... > I'm trying to avoid doing a script like ...
    (comp.unix.shell)
  • Search & Replace in multiple files
    ... I'm looking for a command to do some search & replace into multiple files. ... I'm trying to avoid doing a script like (in ksh) ...
    (comp.unix.shell)
  • digitially Sign multple files
    ... signcode.exe does not seem to support signing multiple files with the same ... certificate. ... Is there any way to sign multiple files at the same time (to ... avoid the rather insecure repeated entry of a password)? ...
    (microsoft.public.platformsdk.security)
  • Re: Search & Replace in multiple files
    ... > I'm looking for a command to do some search & replace into multiple files. ... > I'm trying to avoid doing a script like (in ksh) ...
    (comp.unix.shell)