Results 1 to 4 of 4
  1. #1
    emmett is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Feb 2012
    Posts
    4

    Import Excel file to Access

    Hi,



    I am very new to this. I have taken over the responsibilities In my organisation of ensuring that any excel files imported to access can be viewed on an excel spreadsheet which uses a macro.

    The steps involved are:

    1. Excel file imported to Access.
    2. Users have an excel spreadsheet which pulls the information from Access.

    From time to time the table could be missing one row to anything up to 400 rows. I have gone through the source excel file and everything seems fine for import, the files import successfully and they can be viewed in Access. I am not sure if there is an issue between the Excel spreadsheet pulling the info from Access because, as I said, this happens from time to time. If the user who imports the excel file notices that there are rows in a table missing in Access, they will import the file again and all rows will appear but the user may end up having to do this repeatedly which is a waste.

    Has anyone experienced this?

  2. #2
    emmett is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Feb 2012
    Posts
    4
    Hi everyone,

    I see this ropic has received a good amount of views but no replies. Just to add to this. I have ensure each fields datatypes upon import are correct so Access will import the correct data and not leave anything etc but I still have the problem where lines (rows) of the imported spreadsheet are missing.

    Could this be a case sensitive problem? A colleague suggested that but I am unsure. Any ideas would be a great help.

    Thanks,
    Emmett

  3. #3
    Chan_123 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Apr 2012
    Posts
    1
    Hi
    Emmett

    Check you source file, it may have some column contain text and number format data ,and when you try to import into access then it will import only one type of data.


    Chan

  4. #4
    emmett is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Feb 2012
    Posts
    4
    Hi Chan,

    Thank you for your reply. Apologies for only getting back to you now. The problem seemed to be cause by leading zeros. This has been corrected and there doesn't seem to be an issue with the source file.

    Thanks again!
    Emmett

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

Similar Threads

  1. import excel file to access 2003 yes, access 2007 no
    By stapik in forum Import/Export Data
    Replies: 9
    Last Post: 07-27-2011, 07:09 AM
  2. Browse for Excel File and Import
    By AKQTS in forum Programming
    Replies: 1
    Last Post: 07-12-2011, 07:33 AM
  3. Import Excel File Using Macro?
    By oregoncrete in forum Import/Export Data
    Replies: 0
    Last Post: 04-05-2011, 12:26 PM
  4. Splitting an Excel File into Multiple Access Tables on Import
    By TheWolfster in forum Import/Export Data
    Replies: 4
    Last Post: 04-29-2010, 04:52 AM
  5. Replies: 0
    Last Post: 04-29-2009, 04:27 PM

Tags for this Thread

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