Really stuck on exporting my final dataset to Access. Which I expected to be the easy bit.
The Access database is shared on dropbox but I am working with the synched copy on my hard disk.
Stages so far
(1) created a connection using ODBC & SQL:2003, seems to work OK after upgrading to 64bit office and installing a raft of Microsoft downloaded utilities
(2) Using the ‘Database command’ action have created a table in an Access database, with correct field names. But the database the table is created in not specified anywhere in this connection - where does it come from (I did enter the path for the database when struggling to create the connection string)? How is the database name, rather than the table name, normally specified?
(3) Having created the table I am using the ‘Export to Database’ action I get error:
Error: Invalid table name “C:\USERS\JOHNS\DROPBOX\xxxxDEV\xxxxALL.accdb.Manuf_ENCODE_TRIAL”. Expected either table_name or schema_name.table_name.
Source: Action “Export to database” in table “Manuf_ENCODE” in project “C:\Users\JohnS\Dropbox\xxxx\EasyMorph\ProdDataExercise.morph”
Any guidance welcome.
BTW I am a bit lost why exporting/importing (my next challenge) a dataset to/from Access is materially more difficult than sending it to Excel.