Importing in Access
Results 1 to 3 of 3

Thread: Importing in Access

  1. #1
    Flash M0nkey
    Join Date
    Sep 2001
    Posts
    3,447

    Importing in Access

    Ok I have a series of txt files which were exported from access using fixed width. I want to import these txt files back into access so they are easily queryable.

    I know when exporting you can set up specs so they all remain the same - is there any way of doing this for imports?

    if you imagine you have

    customer name - character spaces 25
    product - character spaces 50
    price - character spaces 10

    and so on - i want to be able to load these files as a batch keeping each item in the correct column - can it be done without manually importing each file and setting the column breaks?

    v_Ln

  2. #2
    Senior Member nihil's Avatar
    Join Date
    Jul 2003
    Location
    United Kingdom: Bridlington
    Posts
    17,190
    Hi Val,

    Have you tried an update query?

    Cheers

  3. #3
    Flash M0nkey
    Join Date
    Sep 2001
    Posts
    3,447
    nihil thanks for the suggestion but got it sussed
    just set the import specs (width per column etc) and then created a macro to import the files rather than having to do it individually

    thanks tho

    v_Ln

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •