|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Export table and re-importing
Hi
I have a need to export a table to some of my remote users who will then need to import the data to update their database. I presumed to use the following: DoCmd.TransferText acExportDelim, , "tblSchedule", "C:\Out\schedule.txt" This works fine now, but problems occur when trying to import it. I use Importdelim, but get error 2391 Field F1 does not exist in destination table tblSchedule. Surely if I what I import should be same as what I export ? Any help to work this out would be appreciated. Thanks |
|
#2
|
||||
|
||||
|
Are you exporting your file using a delimeter ie. | or , ? You need to make sure that for every field, you have this delimeter.
Example: firstname|lastname|middlename| All your fields must have this delimeter including the last one. If you do the following: firstname|lastname|middlename A carriage return character will get appended to your text file and access will try to interpret this character as another column. |
|
#3
|
|||
|
|||
|
Exporting/Importing text
Hi
Yes, it is comma delimited and all fields appear to be matched OK. Any ideas ? Thanks. |
![]() |
| Viewing: ASP Free Forums > Programming > Visual Basic Programming > Export table and re-importing |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|