alexfwalker81
Member
- Local time
- Yesterday, 16:53
- Joined
- Feb 26, 2016
- Messages
- 100
I'm importing data from eBay, Amazon and my own website into individual tables in Access. I'll then simplify each table and create queries which pull out the common data fields (such as transaction date, SKU, quantity etc etc) and append these all into a master table so that I can analyse sales by channel, and overall, easily.
However, each of these sources treat the dates differently and I have had to import the data into Short Text fields.
Amazon, for example, formats their dates like this; 2023-09-03T22:50:08+00:00
eBay formats their dates like this; 13 Sep 2023
I can easily extract something which looks like a date from these data, with something like left([field],10) for Amazon and some weird combination of left, mid and right for eBay. What I don't know to do is to make Access then recognise this as a Date/Time field as I append it into the aforementioned master table.
I can work with VBA to some extent. (In other words, if you give me VBA, I know where to copy and paste it and make basic amendments to make it work!)
Thanks in advance!
However, each of these sources treat the dates differently and I have had to import the data into Short Text fields.
Amazon, for example, formats their dates like this; 2023-09-03T22:50:08+00:00
eBay formats their dates like this; 13 Sep 2023
I can easily extract something which looks like a date from these data, with something like left([field],10) for Amazon and some weird combination of left, mid and right for eBay. What I don't know to do is to make Access then recognise this as a Date/Time field as I append it into the aforementioned master table.
I can work with VBA to some extent. (In other words, if you give me VBA, I know where to copy and paste it and make basic amendments to make it work!)
Thanks in advance!