vba,xfer

[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.version is
office2003.

 

[John W. Vinson]

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.version is
office2003.

Do you have a question, Igg? If so it's certainly not comprehensible from the
code above.

 

[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?.