Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hello.
    (Access 2007)
    I'm importing a csv where the first row has field names containing dots (periods .). So I make this the first row of the data
    and then manually create these as the field names - having removed the dots.
    Has anyone a procedure that could automate this re-naming of the fields? Thanks, Andy.

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Andy,

    When you have a cvs file with the first row has field names containing dots, like this :
    [attachment=86743:cvsNotepad.jpg]
    you may import the file with the import wizard. The wizard will remove the dots. Like this result :
    [[attachment=86744:cvsAccess.jpg]
    Attached Images Attached Images
    Francois

  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts
    If you want to import it by code, you can, but you have to use Import Specifications. A line like this :

    DoCmd.TransferText acImportDelim, "Book1ImportSpecifications", "Book1", "D:\Book1.csv", True
    Francois

Posting Permissions

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