I have a file that I would like to import into access, now in that file there's a field called "Category Path". In this field there's a varying amount of information and this changes from row to row so it might be abit tedious.
What I would like to know is how would i got about trimming some of the data away leaving the information that I can use. Some of the information is before and after the data that i need.
I am thinking i may need to run that script/query and create a whole new table from it to get what I want.
(Before) :Component:DRAM Memory:Desktop DRAM:DDR3 (240 Pin):DDR3 1066:
(After) "DRAM Memory"
(Before) :Component:Solid State Drive:SATA3:
(After) Solid State Drives
(Before) :Component:USB Drive:2.0 USB Drive:32GB:
(After) USB Drive
(Before) :PC & Laptop:Accessory:Battery & Charger:
(After) PC & Laptop
(Before) :Hardware & Software:Server & Workstation:Workstation Barebone:
(After) Hardware & Software
Is this even possible in Access??