I want to import a .txt via VBA. this text need a specification and I use an
Access Project (and I don't think it's possible to save specification in a .
adp). so I don't success with the Transfertext method. Any idea?

I want to link my Outlook Address Book to access and use it as my customer's
table.  Is it possible to have an ID field in this Outlook table so that
there can't be any duplicates and I can create a relationship to my Delivery
Table?

I am using the transferdatabase action in a macro. I will be importing
several dozen files that only vary by a single name. How can I use a variable
in the database name argument that prompts the user for a parameter?

I am at Step 4 of the Import Spreadsheet Wizard in Access and I can see all
of the fields listed from my Excel Spreadhseeet. The problem is, in the
wizrd, in the Field Options section, I can't seem to select the Column that
I do not want imported. The forst column from my Excel ...

I have created a link to a Dbase file in an Access 2000 database.  
Periodically, the Dbase file data will change, but the structure will remain
the same.  The path and/or filename could change, however.  I would like to
be able to adjust the link to point to the new Dbase file ...

I have a stored procedure on a SQL server database that I would like to
execute and return records to my Access client.  The help file got me to the
point that I can create a pass through query, but I can't find documentation
on how to format the stored procedure call.  I deally, ...

Hi, I have set up an access databse that links to several different excel
spreadsheets that contain information on each property site such as
vegetation condition, forest health etc.  Is there any way that when creating
a report in access, that certain information from the excel ...

In practice, what is the cutover point where we would want to go to SQL
Server?  I have a user with two Access databases, one is 850MB and one is
1.02GB in size, after compaction.  Both are on drives mapped to a Win2K
server.  Her queries take hours to run.  There are a couple of ...

I want to know if Access 97 can use the MyODBC ODBC data source to connect to
a remote MySQL database. I know this is possible in 2000 upwards but I have
some clients with older versions of Office.

I'm using this logic to import Excel data into Access.
Public Sub ImportProtected(strFile As String, strPassword As String)
Dim oExcel As Object, oWb As Object
Set oExcel = CreateObject("Excel.Application")

I have a need to get an Execl workbook from an Outlook Public Folder.  My
preference would be to import data directly from the workbook in the Public
Folder, but I will settle for copying it to another location if necessary.  I
assume this would be using Outlook objects much like ...

My client has an Access database on their servers. The web hosting will be
through a different company, and the website needs access to the database.
I thought about replicating the database on the web server, so that my
client could just "synchronize now", and get all the ...

I have over 500,000 lines of information from a PeopleSoft query and Excel
will not hold that much information.  I need to download my query information
to Access instead.  Can you tell me how to do this

I have an access database that was burned to a CD.  I would like to copy it
over to my system or upsize/import to SQL.
The error I keep getting is "Cannot start your application.  The workgroup
information file is missing or opened exclusively by another user"

Hi everyone, please excuse the newbie question. I need to know the basics of
how to programmatically update and Access database from an Excel spread
sheet. I'm thinking of having a "watch directory" and running some automatic
cron job to update the Access database from an Excel ...