Hi - I've got some code which saves a file to my local drive from an FTP server and then imports it into Access.
Unfortunately the file (in .csv format) is exported with a strange Null handler...
All instances of Null are replaced by the word "None"...
This causes Access to reject field type definitions (date etc...) as it sees the fields as text.
What's the best way to handle this - can I somehow convert the .csv file within my procedure then import it (the most desirable option). Or is there some way of quickly making the changes after importing the file into an all text field Table?
For now we'll assume we're not able to get those exporting it to change their Null definition.
Thanks!
Alastair.
Start Free Trial
