I need to import a dbf file into access and when I select 'files of type' the
only option is MS Access files.
None of the other options are available

I'm trying to run a For each statement, I end up in the debugger with
Run-time error '3251' Operation is not supported for this type of object.
What I'm trying to do is to put the Fieldnames in top of the exported file.
This is as far as I've reached:

I have put togetehr an Access application that requires
the USER to click a command button to import data to be
loaded/added to a table. The import macro will ask the
User if he is sure the data is available in the pre-

Is there a way to update the link to an Excel spreadsheet without going
through the Linked Table Manager?  Thanks.

I'm trying to export a table in access to excel. I get the error that the
"you tried to use a form,report,or datasheet that contains an OLE object, but
the OLE server(the application used to create the object) may not be
registered properly.Reinstall the OLE server to register it ...

can outlook contact linked table be use with other table in acces form?  I
have eastablished relationship, but I am unable to enter info in form fields
or query fields.

They need for me to import a text file into an Access file - no problem. Then
import another text file into another Access file and compare records between
them. Non dups records in second file need to be appended to the first file.
Duplicates are defined as the 5 leftmost chr of ...

I've set up this VB command,
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9,
"tbl.MasterTestResults", "C:\Data\MasterTestResults.xls", ,
"tblMasterTestResults"

I am using Office Professional 2003.  I want to import XML data into a new
Access database but the "Get External Data" option on the File menu is greyed
out.  
Any ideas how I can get this to work?

Currently, Users hit a button on a website, initiating a Command Prompt
session with a legacy database that prompts for User name and password before
allowing the User to run a report. We want to automate the transfer of the
report output to Access.

I am looking for a way to export worksheets similar to Access. Selecting a
better delimiter (prefer | over TAB and CSV) and NO QUOTES around text
strings.
I really wish MS would add this DIRECTLY into Excel (anyone in Redmond

I'm able to import various text files with TransferText in a macro, but that
limits me to a single default filename and location.  The text files are
always the same format and they always go into the same table, but they have
various filenames, like test20050526 and test20050527 ...

i'd like to post my access bookcolection to book collextors bck file format,
any suggestions?

Is there a way of moving data from a linked table to a permanent table. The
"temporary" table is linked to a comma-delimited text file. However, the text
file only holds one set of records at a time. I can import those records.
When the text file is loaded with new imformation, ...

I am setting up a database and I want to know can I include the CONVERT
function from an Excel sheet in the database. How do I reference the location
of the data point (i.e. the cell address (D390) in the Excel sheet example
below)  within the data table? Is it feasible to do ...