Search results

Still need some help I'm afriad I was getting a syntax error, till I realised I had my variables within quotes. Now the error I'm getting is: Just to be clear, this code is running from Excel. I have run compact and repair and tried making it a secured database.

Brilliant, thanks. That does make perfect sense.

Hi all, I have a task to build a simple data base that can analyse some text files. I have this working in a manual way but have to import a lot of columns as text due to the fields containing different data. The text files that I'm importing can be retty massive, say 5 million rows max. They...

Hi all, Really sorry if this has been aswered already. I have tried searching this forum and Google but haven't found anything thus far. Possibly because there are better ways of doing this. I have an Excel workbook with 9 fields. The entered data begins on row 7, I want some code that when a...