Results 1 to 5 of 5
  1. #1
    jesleon is offline Novice
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Aug 2010
    Posts
    3

    Exclamation Excel Import

    Hello Everybody,



    While writing a new DB (Access 2010) I needed to import an Excel sheet and I noticed that there is absolutely no control over what columns are imported and which ones are skipped. I cant believe that any time we are going to import data we are forced to import the entire spreadsheet.

    It seams like you can now just point click and hit finish, No OPTIONS

    I need to be able to skip columns in excel sheets

  2. #2
    pkstormy's Avatar
    pkstormy is offline Access/SQL Server Expert
    Windows XP Access 2003
    Join Date
    Mar 2010
    Location
    Madison
    Posts
    682
    You should be able to change the excel file extension from *.xls to *.csv and then in MSAccess, create an Import File Specification (and use the docmd.transfertext command). This would then allow you to specify which columns. But it's probably easier to just import the excel file and then run a make-table query to create a table which has just the columns you want.

  3. #3
    jesleon is offline Novice
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Aug 2010
    Posts
    3
    Thanks pkstormy, that's exactly what I did. Great minds think alike! ha just kinnding thanks again for your reply

  4. #4
    pkstormy's Avatar
    pkstormy is offline Access/SQL Server Expert
    Windows XP Access 2003
    Join Date
    Mar 2010
    Location
    Madison
    Posts
    682
    Jesleon,

    You may also find this handy for importing excel files. It will import multiple excel files automatically from whatever folder is selected (it has a browse button on the import form to easily select the folder.)

  5. #5
    jesleon is offline Novice
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Aug 2010
    Posts
    3
    Very nice!

    Thanks again phstormy, this will very usefull in the project.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Import from Excel Using TransferSpreadsheet
    By P5C768 in forum Import/Export Data
    Replies: 10
    Last Post: 05-01-2013, 01:17 PM
  2. Import Excel with SQL - again
    By tpcervelo in forum Queries
    Replies: 1
    Last Post: 08-06-2010, 08:13 PM
  3. Import Excel into access does not work
    By hawg1 in forum Import/Export Data
    Replies: 1
    Last Post: 05-28-2010, 12:05 PM
  4. VBA to open excel, import on close of excel
    By bdaniel in forum Programming
    Replies: 0
    Last Post: 03-20-2010, 02:45 PM
  5. Import excel sheets to access.
    By calexandru in forum Import/Export Data
    Replies: 0
    Last Post: 08-19-2009, 09:44 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums