import

[igg via AccessMonster.com]

since tbl_data has not temp field, no_temp spec should skip the temp field in
csv file.

DoCmd.TransferText acImportDelim, no_temp_field, "tbl_data", csvfilepath,
True

But, getting an error, table "tbl_data" does not have temp field.

 

[Jerry Whittle]

No it won't. If the import spec calls for such a field, and it's not in the
table, you will get an error. You should be able to modify the spec to skip
that field.

 

[igg via AccessMonster.com]

my current database has a table linked to a table on a remote db. remote
database has the specs. That is why my current db does not see the specs on
remote db. how can i import the specs to my local db?.

and, how can i run module on a remote database in silent mode?. access remote
db , run module and exit?.

No it won't. If the import spec calls for such a field, and it's not in the
table, you will get an error. You should be able to modify the spec to skip
that field.

since tbl_data has not temp field, no_temp spec should skip the temp field in
csv file.

[quoted text clipped - 3 lines]

But, getting an error, table "tbl_data" does not have temp field.