TransferText

  • Thread starter Thread starter CT
  • Start date Start date
C

CT

Can the TransferText method be used from FH db to import
text file using FH spec into BH db? What is the syntx? If
not, how can it be done?

Also, Is table in BH db always overwritten (which is what
I want)when you use TransferDatabase method from FH db?

CT
 
Hi CT,

What is "FH db"?

Can the TransferText method be used from FH db to import
text file using FH spec into BH db? What is the syntx? If
not, how can it be done?

Also, Is table in BH db always overwritten (which is what
I want)when you use TransferDatabase method from FH db?

CT
Click to expand...
 
Front half, Back half.
-----Original Message-----
Hi CT,

What is "FH db"?

Can the TransferText method be used from FH db to import
text file using FH spec into BH db? What is the syntx? If
not, how can it be done?

Also, Is table in BH db always overwritten (which is what
I want)when you use TransferDatabase method from FH db?

CT
Click to expand...

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
Click to expand...
 
I'll guess that means the same as front end and back end.

TransferText can only operate on a table or query in the current
database, so if you want to use it you need to create the table in the
back end, then a linked table in the front end, and finally import the
data to the linked table.

Alternatively it may be possible to do it in one step with a make-table
query something like this:

SELECT * INTO MyTable In D:\Folder\MyBackEnd.mdb
FROM [Text;HDR=No;Database=D:\Folder\;].MyFile#txt

but I wouldn't do this because it doesn't give you full control over the
field types, default values, validation rules, relationships etc. in the
back end.

I don't quite understand your second question. It seems as if you want
to copy tables from the front end to the back end and overwrite existing
tables in the back end. If you're envisaging this as a routine
operation, I suspect there's something wrong with the design of the
database. If it's for distributing updates or other "special purpose"
use it could be OK; why not try it and discover whether the existing
table is overwritten?



Front half, Back half.
-----Original Message-----
Hi CT,

What is "FH db"?

Can the TransferText method be used from FH db to import
text file using FH spec into BH db? What is the syntx? If
not, how can it be done?

Also, Is table in BH db always overwritten (which is what
I want)when you use TransferDatabase method from FH db?

CT
Click to expand...

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
Click to expand...
Click to expand...
 
Thanks for the information. The reason for my second
question related to the fact the trying to empty a table
in the back end database thru a link using delete sql was
taking too much time. Maybe due to number of records.
Will continue to try different options.

CT
-----Original Message-----
I'll guess that means the same as front end and back end.

TransferText can only operate on a table or query in the current
database, so if you want to use it you need to create the table in the
back end, then a linked table in the front end, and finally import the
data to the linked table.

Alternatively it may be possible to do it in one step with a make-table
query something like this:

SELECT * INTO MyTable In D:\Folder\MyBackEnd.mdb
FROM [Text;HDR=No;Database=D:\Folder\;].MyFile#txt

but I wouldn't do this because it doesn't give you full control over the
field types, default values, validation rules, relationships etc. in the
back end.

I don't quite understand your second question. It seems as if you want
to copy tables from the front end to the back end and overwrite existing
tables in the back end. If you're envisaging this as a routine
operation, I suspect there's something wrong with the design of the
database. If it's for distributing updates or other "special purpose"
use it could be OK; why not try it and discover whether the existing
table is overwritten?



Front half, Back half.
-----Original Message-----
Hi CT,

What is "FH db"?

On Fri, 12 Nov 2004 13:36:23 -0800, "CT"

Can the TransferText method be used from FH db to import
text file using FH spec into BH db? What is the
Click to expand...
syntx?
If
not, how can it be done?

Also, Is table in BH db always overwritten (which is what
I want)when you use TransferDatabase method from FH db?

CT

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
Click to expand...
Click to expand...

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
Click to expand...
 
Back
Top