Any easy way to convert from Excel Columns to a joined Table?

[Montez659]

I am having to import a file, and I can do it manually if necessary as it will only be a one time conversion, but there are five columns that I want to eventually turn in one joined table. Five columns become five codes, and the record ID that they will be linked to, plus a date field. What is the easiest way to do this?

 

[Joe4]

I am not quite sure what you mean by a "joined" table. Joined to what?
Anything that you import into Access becomes its own table without you having to do anything "special" to make it a table.

 

[Montez659]

Sorry, let me clarify. In the end, I want there to be a Joined Table. I will have tblRFP, tblTrackingCodes, and tblJOINEDtrackingRFP. Right now I have 20 columns in an Excel sheet, and about 8 of those fields are just "Date such and such happened." Those eight fields will be a Joined table with a many to many relationship in the final design.

My problem is how to get that info into the Joined table whereas if i do a standard import, like you said, it will create it's own table.

 

[Norie]

An union query for the results, then a make table if you want a table.

Exactly how to do it depends on the structure of the imported data and how you want to restructure it.

Let's say you've got something like this after import:
<TABLE border=1 cellSpacing=0 bgColor=#ffffff><CAPTION>TheTable</CAPTION><THEAD><TR><TH bgColor=#c0c0c0 borderColor=#000000>ID</TH><TH bgColor=#c0c0c0 borderColor=#000000>Code1</TH><TH bgColor=#c0c0c0 borderColor=#000000>Code2</TH><TH bgColor=#c0c0c0 borderColor=#000000>Code3</TH><TH bgColor=#c0c0c0 borderColor=#000000>Code4</TH></TR></THEAD><TBODY><TR vAlign=top><TD borderColor=#d0d7e5 align=right>4</TD><TD borderColor=#d0d7e5 align=right>01/04/2011</TD><TD borderColor=#d0d7e5 align=right>19/03/2011</TD><TD borderColor=#d0d7e5 align=right>09/04/2011</TD><TD borderColor=#d0d7e5 align=right>06/04/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>10</TD><TD borderColor=#d0d7e5 align=right>
</TD><TD borderColor=#d0d7e5 align=right>17/04/2011</TD><TD borderColor=#d0d7e5 align=right>12/04/2011</TD><TD borderColor=#d0d7e5 align=right>12/04/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>14</TD><TD borderColor=#d0d7e5 align=right>05/04/2011</TD><TD borderColor=#d0d7e5 align=right>24/03/2011</TD><TD borderColor=#d0d7e5 align=right>28/03/2011</TD><TD borderColor=#d0d7e5 align=right>07/04/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>24</TD><TD borderColor=#d0d7e5 align=right>
</TD><TD borderColor=#d0d7e5 align=right>14/04/2011</TD><TD borderColor=#d0d7e5 align=right>
</TD><TD borderColor=#d0d7e5 align=right>29/03/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>25</TD><TD borderColor=#d0d7e5 align=right>11/04/2011</TD><TD borderColor=#d0d7e5 align=right>
</TD><TD borderColor=#d0d7e5 align=right>27/03/2011</TD><TD borderColor=#d0d7e5 align=right>11/04/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>26</TD><TD borderColor=#d0d7e5 align=right>23/03/2011</TD><TD borderColor=#d0d7e5 align=right>10/04/2011</TD><TD borderColor=#d0d7e5 align=right>30/03/2011</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>29</TD><TD borderColor=#d0d7e5 align=right>
</TD><TD borderColor=#d0d7e5 align=right>30/03/2011</TD><TD borderColor=#d0d7e5 align=right>01/04/2011</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>33</TD><TD borderColor=#d0d7e5 align=right>07/04/2011</TD><TD borderColor=#d0d7e5 align=right>11/04/2011</TD><TD borderColor=#d0d7e5 align=right>22/03/2011</TD><TD borderColor=#d0d7e5 align=right>16/04/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>39</TD><TD borderColor=#d0d7e5 align=right>10/04/2011</TD><TD borderColor=#d0d7e5 align=right>20/03/2011</TD><TD borderColor=#d0d7e5 align=right>
</TD><TD borderColor=#d0d7e5 align=right>09/04/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>42</TD><TD borderColor=#d0d7e5 align=right>
</TD><TD borderColor=#d0d7e5 align=right>13/04/2011</TD><TD borderColor=#d0d7e5 align=right>23/03/2011</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>45</TD><TD borderColor=#d0d7e5 align=right>
</TD><TD borderColor=#d0d7e5 align=right>
</TD><TD borderColor=#d0d7e5 align=right>
</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>49</TD><TD borderColor=#d0d7e5 align=right>
</TD><TD borderColor=#d0d7e5 align=right>21/03/2011</TD><TD borderColor=#d0d7e5 align=right>01/04/2011</TD><TD borderColor=#d0d7e5 align=right>15/04/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>51</TD><TD borderColor=#d0d7e5 align=right>31/03/2011</TD><TD borderColor=#d0d7e5 align=right>27/03/2011</TD><TD borderColor=#d0d7e5 align=right>19/03/2011</TD><TD borderColor=#d0d7e5 align=right>20/03/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>53</TD><TD borderColor=#d0d7e5 align=right>15/04/2011</TD><TD borderColor=#d0d7e5 align=right>27/03/2011</TD><TD borderColor=#d0d7e5 align=right>31/03/2011</TD><TD borderColor=#d0d7e5 align=right>10/04/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>57</TD><TD borderColor=#d0d7e5 align=right>24/03/2011</TD><TD borderColor=#d0d7e5 align=right>25/03/2011</TD><TD borderColor=#d0d7e5 align=right>11/04/2011</TD><TD borderColor=#d0d7e5 align=right>24/03/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>66</TD><TD borderColor=#d0d7e5 align=right>
</TD><TD borderColor=#d0d7e5 align=right>
</TD><TD borderColor=#d0d7e5 align=right>
</TD><TD borderColor=#d0d7e5 align=right>13/04/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>69</TD><TD borderColor=#d0d7e5 align=right>
</TD><TD borderColor=#d0d7e5 align=right>
</TD><TD borderColor=#d0d7e5 align=right>
</TD><TD borderColor=#d0d7e5 align=right>07/04/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>77</TD><TD borderColor=#d0d7e5 align=right>
</TD><TD borderColor=#d0d7e5 align=right>03/04/2011</TD><TD borderColor=#d0d7e5 align=right>25/03/2011</TD><TD borderColor=#d0d7e5 align=right>24/03/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>81</TD><TD borderColor=#d0d7e5 align=right>
</TD><TD borderColor=#d0d7e5 align=right>19/03/2011</TD><TD borderColor=#d0d7e5 align=right>03/04/2011</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>91</TD><TD borderColor=#d0d7e5 align=right>08/04/2011</TD><TD borderColor=#d0d7e5 align=right>02/04/2011</TD><TD borderColor=#d0d7e5 align=right>27/03/2011</TD><TD borderColor=#d0d7e5 align=right>21/03/2011</TD></TR></TBODY><TFOOT></TFOOT></TABLE>

This UNION query:

SELECT TheTable.ID, "Code1" AS Code, TheTable.Code1 AS DateField
FROM TheTable

UNION ALL

SELECT TheTable.ID, "Code2" AS Code, TheTable.Code2 AS DateField
FROM TheTable

UNION ALL

SELECT TheTable.ID, "Code3" AS Code, TheTable.Code3 AS DateField
FROM TheTable

UNION ALL

SELECT TheTable.ID, "Code4" AS Code, TheTable.Code4 AS DateField
FROM TheTable

Will produce these results:

<TABLE border=1 cellSpacing=0 bgColor=#ffffff><CAPTION>TheUnionQuery</CAPTION><THEAD><TR><TH bgColor=#c0c0c0 borderColor=#000000>ID</TH><TH bgColor=#c0c0c0 borderColor=#000000>Code</TH><TH bgColor=#c0c0c0 borderColor=#000000>DateField</TH></TR></THEAD><TBODY><TR vAlign=top><TD borderColor=#d0d7e5 align=right>57</TD><TD borderColor=#d0d7e5>Code1</TD><TD borderColor=#d0d7e5 align=right>24/03/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>33</TD><TD borderColor=#d0d7e5>Code1</TD><TD borderColor=#d0d7e5 align=right>07/04/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>29</TD><TD borderColor=#d0d7e5>Code1</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>10</TD><TD borderColor=#d0d7e5>Code1</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>77</TD><TD borderColor=#d0d7e5>Code1</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>39</TD><TD borderColor=#d0d7e5>Code1</TD><TD borderColor=#d0d7e5 align=right>10/04/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>91</TD><TD borderColor=#d0d7e5>Code1</TD><TD borderColor=#d0d7e5 align=right>08/04/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>42</TD><TD borderColor=#d0d7e5>Code1</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>49</TD><TD borderColor=#d0d7e5>Code1</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>24</TD><TD borderColor=#d0d7e5>Code1</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>25</TD><TD borderColor=#d0d7e5>Code1</TD><TD borderColor=#d0d7e5 align=right>11/04/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>45</TD><TD borderColor=#d0d7e5>Code1</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>53</TD><TD borderColor=#d0d7e5>Code1</TD><TD borderColor=#d0d7e5 align=right>15/04/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>4</TD><TD borderColor=#d0d7e5>Code1</TD><TD borderColor=#d0d7e5 align=right>01/04/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>14</TD><TD borderColor=#d0d7e5>Code1</TD><TD borderColor=#d0d7e5 align=right>05/04/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>66</TD><TD borderColor=#d0d7e5>Code1</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>69</TD><TD borderColor=#d0d7e5>Code1</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>26</TD><TD borderColor=#d0d7e5>Code1</TD><TD borderColor=#d0d7e5 align=right>23/03/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>81</TD><TD borderColor=#d0d7e5>Code1</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>51</TD><TD borderColor=#d0d7e5>Code1</TD><TD borderColor=#d0d7e5 align=right>31/03/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>57</TD><TD borderColor=#d0d7e5>Code2</TD><TD borderColor=#d0d7e5 align=right>25/03/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>33</TD><TD borderColor=#d0d7e5>Code2</TD><TD borderColor=#d0d7e5 align=right>11/04/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>29</TD><TD borderColor=#d0d7e5>Code2</TD><TD borderColor=#d0d7e5 align=right>30/03/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>10</TD><TD borderColor=#d0d7e5>Code2</TD><TD borderColor=#d0d7e5 align=right>17/04/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>77</TD><TD borderColor=#d0d7e5>Code2</TD><TD borderColor=#d0d7e5 align=right>03/04/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>39</TD><TD borderColor=#d0d7e5>Code2</TD><TD borderColor=#d0d7e5 align=right>20/03/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>91</TD><TD borderColor=#d0d7e5>Code2</TD><TD borderColor=#d0d7e5 align=right>02/04/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>42</TD><TD borderColor=#d0d7e5>Code2</TD><TD borderColor=#d0d7e5 align=right>13/04/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>49</TD><TD borderColor=#d0d7e5>Code2</TD><TD borderColor=#d0d7e5 align=right>21/03/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>24</TD><TD borderColor=#d0d7e5>Code2</TD><TD borderColor=#d0d7e5 align=right>14/04/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>25</TD><TD borderColor=#d0d7e5>Code2</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>45</TD><TD borderColor=#d0d7e5>Code2</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>53</TD><TD borderColor=#d0d7e5>Code2</TD><TD borderColor=#d0d7e5 align=right>27/03/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>4</TD><TD borderColor=#d0d7e5>Code2</TD><TD borderColor=#d0d7e5 align=right>19/03/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>14</TD><TD borderColor=#d0d7e5>Code2</TD><TD borderColor=#d0d7e5 align=right>24/03/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>66</TD><TD borderColor=#d0d7e5>Code2</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>69</TD><TD borderColor=#d0d7e5>Code2</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>26</TD><TD borderColor=#d0d7e5>Code2</TD><TD borderColor=#d0d7e5 align=right>10/04/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>81</TD><TD borderColor=#d0d7e5>Code2</TD><TD borderColor=#d0d7e5 align=right>19/03/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>51</TD><TD borderColor=#d0d7e5>Code2</TD><TD borderColor=#d0d7e5 align=right>27/03/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>57</TD><TD borderColor=#d0d7e5>Code3</TD><TD borderColor=#d0d7e5 align=right>11/04/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>33</TD><TD borderColor=#d0d7e5>Code3</TD><TD borderColor=#d0d7e5 align=right>22/03/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>29</TD><TD borderColor=#d0d7e5>Code3</TD><TD borderColor=#d0d7e5 align=right>01/04/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>10</TD><TD borderColor=#d0d7e5>Code3</TD><TD borderColor=#d0d7e5 align=right>12/04/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>77</TD><TD borderColor=#d0d7e5>Code3</TD><TD borderColor=#d0d7e5 align=right>25/03/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>39</TD><TD borderColor=#d0d7e5>Code3</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>91</TD><TD borderColor=#d0d7e5>Code3</TD><TD borderColor=#d0d7e5 align=right>27/03/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>42</TD><TD borderColor=#d0d7e5>Code3</TD><TD borderColor=#d0d7e5 align=right>23/03/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>49</TD><TD borderColor=#d0d7e5>Code3</TD><TD borderColor=#d0d7e5 align=right>01/04/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>24</TD><TD borderColor=#d0d7e5>Code3</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>25</TD><TD borderColor=#d0d7e5>Code3</TD><TD borderColor=#d0d7e5 align=right>27/03/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>45</TD><TD borderColor=#d0d7e5>Code3</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>53</TD><TD borderColor=#d0d7e5>Code3</TD><TD borderColor=#d0d7e5 align=right>31/03/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>4</TD><TD borderColor=#d0d7e5>Code3</TD><TD borderColor=#d0d7e5 align=right>09/04/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>14</TD><TD borderColor=#d0d7e5>Code3</TD><TD borderColor=#d0d7e5 align=right>28/03/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>66</TD><TD borderColor=#d0d7e5>Code3</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>69</TD><TD borderColor=#d0d7e5>Code3</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>26</TD><TD borderColor=#d0d7e5>Code3</TD><TD borderColor=#d0d7e5 align=right>30/03/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>81</TD><TD borderColor=#d0d7e5>Code3</TD><TD borderColor=#d0d7e5 align=right>03/04/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>51</TD><TD borderColor=#d0d7e5>Code3</TD><TD borderColor=#d0d7e5 align=right>19/03/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>57</TD><TD borderColor=#d0d7e5>Code4</TD><TD borderColor=#d0d7e5 align=right>24/03/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>33</TD><TD borderColor=#d0d7e5>Code4</TD><TD borderColor=#d0d7e5 align=right>16/04/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>29</TD><TD borderColor=#d0d7e5>Code4</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>10</TD><TD borderColor=#d0d7e5>Code4</TD><TD borderColor=#d0d7e5 align=right>12/04/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>77</TD><TD borderColor=#d0d7e5>Code4</TD><TD borderColor=#d0d7e5 align=right>24/03/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>39</TD><TD borderColor=#d0d7e5>Code4</TD><TD borderColor=#d0d7e5 align=right>09/04/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>91</TD><TD borderColor=#d0d7e5>Code4</TD><TD borderColor=#d0d7e5 align=right>21/03/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>42</TD><TD borderColor=#d0d7e5>Code4</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>49</TD><TD borderColor=#d0d7e5>Code4</TD><TD borderColor=#d0d7e5 align=right>15/04/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>24</TD><TD borderColor=#d0d7e5>Code4</TD><TD borderColor=#d0d7e5 align=right>29/03/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>25</TD><TD borderColor=#d0d7e5>Code4</TD><TD borderColor=#d0d7e5 align=right>11/04/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>45</TD><TD borderColor=#d0d7e5>Code4</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>53</TD><TD borderColor=#d0d7e5>Code4</TD><TD borderColor=#d0d7e5 align=right>10/04/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>4</TD><TD borderColor=#d0d7e5>Code4</TD><TD borderColor=#d0d7e5 align=right>06/04/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>14</TD><TD borderColor=#d0d7e5>Code4</TD><TD borderColor=#d0d7e5 align=right>07/04/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>66</TD><TD borderColor=#d0d7e5>Code4</TD><TD borderColor=#d0d7e5 align=right>13/04/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>69</TD><TD borderColor=#d0d7e5>Code4</TD><TD borderColor=#d0d7e5 align=right>07/04/2011</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>26</TD><TD borderColor=#d0d7e5>Code4</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>81</TD><TD borderColor=#d0d7e5>Code4</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5 align=right>51</TD><TD borderColor=#d0d7e5>Code4</TD><TD borderColor=#d0d7e5 align=right>20/03/2011</TD></TR></TBODY><TFOOT></TFOOT></TABLE>

Which probably isn't what you want but might give you an idea or two.

 

[Montez659]

No, that looks like exactly what I want! Will it create it's own Autonnumber PK?

 

[Joe4]

You could import it directly into the table you want, if it is in the correct structure. Otherwise, you could also use an Append Query to copy the records form your newly imported table into your desired final destination table.

 

[Norie]

No.

The IDs I created myself, well Excel helped I suppose.

I assumed you had existing IDs.

If you don't and you want to use an autonumber then you would do the UNION part but you would then append to an existing table rather than creating a new one.

So you would need to create a blank table with all the relevants fields, including the autonumber.

Actually if you did that you wouldn't have to use the UNION query, you could append the queries that make that up individually.

You might want to do that so you can make sure everything is working properly rather than appending all the data in one go.

 

[Montez659]

Sounds good, I think I got it. Thanks for the help gents!