Share via

HELP: Creating an Import specification file for importing data from excel

Anonymous
2011-02-03T16:57:10+00:00

Hi All,

I know how to save a Import specification file when importing data from a text file into access, But when I import data from excel files, I dont see any "Advance" tab which would allow me to save a import specification file.

Is there a way to do this?

How can I modify data types which are pre-identified by access?

Would I need a stored procedure to do this?

Thanks in advance

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2011-02-03T17:31:21+00:00

    That is correct... very annoying.  You could saving it as a .CSV file Import Specification and then using the Specification in a DoCmdTransferSpreadsheet action.  Do this on a COPY of your database.

    --

    Gina Whipp

    Microsoft MVP (Access)

    Please post all replies to the forum where everyone can benefit.

    OR, if your spreadsheet isn't changing, just create a transition table so you import it to that table and then move the data to the real table afterwards.  That way you can preset the datatypes.

    Bob Larson, Former Access MVP (2008-2010) http://www.btabdevelopment.com (free Access tools, tutorials, and samples)

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2011-02-03T17:05:22+00:00

    That is correct... very annoying.  You could saving it as a .CSV file Import Specification and then using the Specification in a DoCmdTransferSpreadsheet action.  Do this on a COPY of your database.

    --

    Gina Whipp

    Microsoft MVP (Access)

    Please post all replies to the forum where everyone can benefit.

    0 comments