Reply to thread

Message

<blockquote data-quote="Forgotten Illustrator" data-source="post: 189690" data-attributes="member: 17564">I managed to enter the data manually into the database via MS Access successfully. With these instructions (Mind you I was using MS 2007 and it was a bit different ). EDIT: I recommend you use SQL Management Studio as it is a free download.&nbsp; See 2 posts down 1.&nbsp; &nbsp; Start Access 972.&nbsp; &nbsp; Select Blank Database and click OK3.&nbsp; &nbsp; Enter a name and directory, click Create4.&nbsp; &nbsp; Select the Tables tab5.&nbsp; &nbsp; From the File menu select Get External Data - Link Tables6.&nbsp; &nbsp; In the bottom left corner of the displayed dialog will be &quot;Files of type:&quot;. Change this to &quot;ODBC databases&quot;7.&nbsp; &nbsp; A new dialog will be displayed. Click the &quot;Machine Data Source&quot; tab8.&nbsp; &nbsp; Select the Data Source created using ODBC earlier and click OK9.&nbsp; &nbsp; You may need to enter a password for the database.10.&nbsp; &nbsp; You will now see &quot;Link Table&quot; dialog, select and click OK.11.&nbsp; &nbsp; Under your main Table tab you will now see dbo.&lt;database&gt; and double clicking will give a graphical view.</blockquote>

[QUOTE="Forgotten Illustrator, post: 189690, member: 17564"] I managed to enter the data manually into the database via MS Access successfully. With these instructions (Mind you I was using MS 2007 and it was a bit different ). [b]EDIT: I recommend you use SQL Management Studio as it is a free download. See 2 posts down [/b] 1. Start Access 97 2. Select Blank Database and click OK 3. Enter a name and directory, click Create 4. Select the Tables tab 5. From the File menu select Get External Data - Link Tables 6. In the bottom left corner of the displayed dialog will be "Files of type:". Change this to "ODBC databases" 7. A new dialog will be displayed. Click the "Machine Data Source" tab 8. Select the Data Source created using ODBC earlier and click OK 9. You may need to enter a password for the database. 10. You will now see "Link Table" dialog, select and click OK. 11. Under your main Table tab you will now see dbo.<database> and double clicking will give a graphical view. [/QUOTE]

Verification