Hi all,
Having a bit of a brain fart. I have a file that I import into a table in Access 2016. The data ends up like this:
The field PicURLs are zero or more URLs separated by a semicolon delimiter.
I want to store the PicURLs in a separate table that is more normalised.
e.g.
I can't seem to grasp a solution. Is it possible through queries only or is it essential (or simpler) to throw some VBA into the mix?
This will be part of an automated import process.
Thanks for any ideas!
Having a bit of a brain fart. I have a file that I import into a table in Access 2016. The data ends up like this:
Code:
MainTableID PicURLs
1 www.example.com;www.abc.com;www.xyz.com
2
3 www.access-programmers.co.uk
The field PicURLs are zero or more URLs separated by a semicolon delimiter.
I want to store the PicURLs in a separate table that is more normalised.
e.g.
Code:
PicTableID MainTableID PicURL
1 1 www.example.com
2 1 www.abc.com
3 1 www.xyz.com
4 3 www.access-programmers.co.uk
I can't seem to grasp a solution. Is it possible through queries only or is it essential (or simpler) to throw some VBA into the mix?
This will be part of an automated import process.
Thanks for any ideas!