Search results

Hi all I have been having a problem trying to enter a date in a table using vba. I have fixed it now, but can anyone shed any light as to why my two examples use the date format differently but both work??? I know that vba uses the american date format but surely, it should remain the same no...

Hi Thanks for this. This may will come in handy. The reason I wanted something like this is that I'm not entirely sure which columns of data I am going to need from my text file. I know I could import all the data and then use queries, but I was curious about the import specs so wanted to...

Hi all I think I have found a solution now but I want to still ask a couple of questions regarding this as I've spent hours on it. and want to understand a bit more. Sorry, its a bit lengthy... (My solution is right at the bottom) Basically, I want to import text files into an Access table...