flaviooooo
Programmer
Hi,
I'm currently programming an Access ADP, based on SQL data. Now we would like a way to import a textfile into the tables.
Correct me if I'm wrong, but I think the only proper way to do this is through DTS? In an ADP, you can't save an importspecification, so that would be troublesome.
Anyway, the problem lies in the format of the textfield. All textfields are imported properly, but the problem comes when it reaches a datefield. In the textfile, the dates are defined as such:
20061013 (so yyyymmdd)
The field in the table is of type datetime.
Unfortunately when I try to import, I get an error saying that the fieldtypes are not the same. I need to somehow tell the DTS that the yyyymmdd-field, is actually a datefield an transform it properly. But I don't know how I would do this...
Any help?
Kind regards
Fabian
I'm currently programming an Access ADP, based on SQL data. Now we would like a way to import a textfile into the tables.
Correct me if I'm wrong, but I think the only proper way to do this is through DTS? In an ADP, you can't save an importspecification, so that would be troublesome.
Anyway, the problem lies in the format of the textfield. All textfields are imported properly, but the problem comes when it reaches a datefield. In the textfile, the dates are defined as such:
20061013 (so yyyymmdd)
The field in the table is of type datetime.
Unfortunately when I try to import, I get an error saying that the fieldtypes are not the same. I need to somehow tell the DTS that the yyyymmdd-field, is actually a datefield an transform it properly. But I don't know how I would do this...
Any help?
Kind regards
Fabian