Results 1 to 5 of 5
  1. #1
    TheWolfster is offline Novice
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Feb 2010
    Posts
    25

    Splitting an Excel File into Multiple Access Tables on Import

    Hello again,



    I'm learning more and more as to how badly the data is set up where I work.

    Currently, I have many excel files containing 256 columns of data (these are actually coming from .sav (SPSS) files containing 600 or so columns ). Here's the kicker: there are only about 25 rows.

    What I'd like to do, is on import of these excel files, have access divide them up appropriately and create a relationship between the tables.

    The primary key would always be the first column, and the number of columns per access table would vary (no more than 30).

    I could do this manually, with the GUI wizard, but its very time consuming.

    I Google'd for over an hour and didn't find the answer I'm looking for. I'm probably wording my search incorrectly.

    Is this doable?

    Edit: HA! Copied my thread title and Google delivers.

    http://www.mrexcel.com/forum/showthread.php?t=375745

  2. #2
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    sounds like a one time import; split your spread sheets using excel....then import each excel spread sheet into a separate table.....

  3. #3
    TheWolfster is offline Novice
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Feb 2010
    Posts
    25
    Yeah, I might have to. :/

  4. #4
    GaryTBS is offline Novice
    Windows 7 Access 2007
    Join Date
    Apr 2010
    Posts
    1

    Table driven Excel import

    I have a Access app that allows you to define a table of your Excel info, and it will allow you to pull that data into multiple access tables.

  5. #5
    elizas is offline Novice
    Windows XP Access 2002
    Join Date
    Apr 2010
    Posts
    1

    How to Import a XSL File inside a XML File

    This tip describes, how you can use a XSL(extensible StyleSheet file) inside a XML file to generate a HTML format of that file thus making it more user-friendly.

    Let's Convert this XML File to a Html Format Using XSL StyleSheet:

    <?xml version="1.0" encoding="utf-8" ?>
    <?xml-stylesheet type="text/xsl" href="CDDemo.xsl"?>
    <StudentInfo>
    <Student>
    <id value="11" />
    <addr use="HP">
    <streetAddressLine>HindolaRoad</streetAddressLine>
    <streetAddressLine>Dhenkanal</streetAddressLine>
    <city>BBSR</city>
    <state>OR</state>
    <postalCode>12345</postalCode>
    <country>IN/country>
    </addr>
    <name>
    <Prefix>Miss</prefix>
    <FirstName>Monalisha</FirstName>
    <LastName>Nayak</LastName>
    </name>
    <birthTime value="19841102" />
    </Student>
    <Student>
    <id extension="12" />
    <addr use="HP">
    <streetAddressLine>Polasara</streetAddressLine>
    <streetAddressLine>Berhampur</streetAddressLine>
    <city>BBSR</city>
    <state>OR</state>
    <postalCode>12345</postalCode>
    <country>IN/country>
    </addr>
    <name>
    <Prefix>Miss</prefix>
    <FirstName>Surama</FirstName>
    <LastName>Hotta</LastName>
    </name>
    <birthTime value="19850525" />
    </Student>
    </StudentInfo>

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

Similar Threads

  1. Import Specific Cells from Excel to Access
    By Evocube in forum Import/Export Data
    Replies: 2
    Last Post: 01-12-2012, 10:35 AM
  2. XML File Import To Access...Overwrite Issue
    By wipers123 in forum Import/Export Data
    Replies: 0
    Last Post: 02-11-2010, 12:27 PM
  3. Import excel sheets to access.
    By calexandru in forum Import/Export Data
    Replies: 0
    Last Post: 08-19-2009, 09:44 AM
  4. Replies: 0
    Last Post: 04-29-2009, 04:27 PM
  5. Automate Excel Import to Access Related Tables
    By KramerJ in forum Programming
    Replies: 6
    Last Post: 04-04-2009, 04:24 PM

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