Import A File

[kheins]

I am learning Access VB so forgive me if this question is basic in nature. I am having problems importing a file into Access using VB. I can open the old file or delete the old file but I am not able to open and delete or import the file. Can anyone help? Karl

 

[Databaseguy]

Look into the TransferFile method of the DoCmd Object. Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy

 

[kheins]

I do not have that function. Thanks though. Karl

 

[UncleJack]

I think Tyrone meant TransferDatabase rather than TransferFile. You can import a file with the TransferDatabase method. Check Help and it will tell you everything you need to know.

Uncle Jack

 

[kheins]

My only options for Type are Access, FoxPro, Dbase, Jet, or ODBC. The file I am trying to import either in a text format or Excel. Any other ideas? K K H H
K K H H
K K HHHHHH
K K H H
K K H H

 

[Maquis]

Are you just trying to import a text file into a table in Access? If so, just use the transfertext command either in a macro or VB code. (docmd.transfertext for code)

If it's an excel spreadsheet then use "TransferSpreadsheet" instead. Maq B-)
<insert witty signature here>