Import documents Saved in AccessDB into SQL server
-
I wonder if anyone has tried to do this
Having been asked to examine the ability to upscale a database from the AccessDB one of our teams had developed I started looking at the information in it
In one of the columns they have stored "Supporting Documentation" such as word documents and emails with a data type of attachment in Accessdb
Pulling the data into SQL via SSIS just leaves us with a column that contains the names of the documents and not the actual documents themselves.
When I have looked at the table as part of a query someone has written I noted there were three separate fields as a subset of the field as in the screen grab below
Does anyone know if and how these can be accessed ?
TIA
Richard
-
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
-
I would break the SupportingDocs stuff out into a separate table with the foreign key (do this in Access) and then import that. I'd have to play with it a little. I remember having to fix stuff like this in FileMaker like 25 years ago, and that's how you'd do it in FileMaker, too.
-
I haven't dealt with Access attachments, but I'd agree a separate table is needed. These might be docs in the file system, with a pointer in the Access db. FileStream does this in SQL, but you can just load these as binary files. I have no idea how to do this, but a few links:
https://sourcedaddy.com/ms-access/image-varbinarmax-and-ole-data.html
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply