Import Office 2007 (xlsx) Spreadsheet into an Access 2003 MDB

Posted on 2012-09-21
Last Modified: 2012-09-25
I have client currently using Access 2003 with no plans to upgrade to a newer version of Access.

One of their customers is going to be sending spreadsheets to be imported into the Access 2003 MDB.  The customer spreadsheets are generated in a newer version of Excel and come in with an xlsx extension.   My client has no say in the format of the sent spreadsheet.

Is their any way to import one of the xlsx spreadsheets directly into Access 2003 without opening it an saving as an xls file?

These users are not particularly technical and the best workflow would if the system could import the file in the format it is sent.
Question by:mlcktmguy
    LVL 8

    Expert Comment

    you can run this by task manager every 5 min on a folder then its converting it:
    LVL 14

    Accepted Solution

    The best long-term option is for your client to dictate to customers that they can import .csv files -- and provide an acceptable format for the .csv.  The reason for this is that software versions will always be changing.  Today a customer wants to use Excel 2010, tomorrow a customer will be using Excel 2012...and of course there are the few companies who have decided to get off M$'s merry-go-round.

    .CSV will work for all of these customers, and will be compantible no matter what application the source file comes from.

    I know you assert your client has "no say" to the format, but in my experience this assertion is largely incorrect.  Whenever I've delved into it for my clients, they have always discovered that they actually do have a strong say in the matter.

    If in fact your client can not receive data as .csv from their customers, your client will need to take on the training burdon of "save as"...either to older Excel format or to .csv.  Or you might find from an workflow perspective you can create some VBA code in an Excel 2010 spreadshet to do the import/export with a single keystroke.  For that matter, you could even set up a direct ODBC connected Excel spreadsheet to be used for importing the data.
    LVL 1

    Author Comment

    CNET seemed to like it but there are some very bad reviews for users.  How much is the pay version?  I didn't see that information in your link?
    LVL 84
    They don't have to update Access, but if they have customers (read: people who PAY them) then they should make every effort to accommodate those customers - especially when we're talking about something as innocuous and relatively inexpensive as upgrading to Excel 2007/2010.

    I would be very, very leery of a conversion program like this. As others have said, a CSV file would be preferred to anything else, and the customer would be easily able to generate that.
    LVL 1

    Author Closing Comment

    Good advice.  That's the way we ended up going.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Join & Write a Comment

    In the previous article, Using a Critera Form to Filter Records (, the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
    I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
    In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now