i have a text file located at
http://www.easara.com/downloads/PayRollUpdates/CurrentTables/Readme.txt
and im trying to get access2003 to copy it to my local machine (C: drive)
ive tried using the following code but i get errors. Can anyone point me in

i do not understand the meaning of the formular {=table(c11;b22)}.
please explain to me!

My company uses an ASE400 Database.
AKA JD Edwards - Worldvision
AKA people soft
I can not seem to link to the tables and get the correct

There is an .mde file on the network I'd like to see the relationships. I
linked to it using a regular .mdb file.  I could only see the tables.  I
tried linking using an .adp file.  I installed the MDSE. I tried linking via
T-SQL and in the test connection I got the error:

All
I am trying to use access to modify data within a Teradata DB.  I have the
following code that access Teradata thru the ODBC drivers.
   Dim sql As String

I have been used a link to CSV file in my aplications since Access 97 (and
later also 2000, 2002 and 2003) and I didn't have any problems with the
data.
Now I'm using Access 2007 (12.0.4518.1014) MSO (12.0.6017.5000) and today I

Ok...  so I have now exported the data from excel and can import the data
with the import wizard into an existing table but my VBA code gives me an
error when I try to automate it...
DoCmd.TransferText , , "tblImport", sFile, False

 I have a text file that I create from a spreadsheet that has data
formatted as such:
First,Last,Date,StartTime,StopTime
I want to import the data into an existing table in access with the

I export information from an excel file into an access table which I then run
reports off.  The problem is, when I bring the excel information into a new
table, for some reason, one of the cells refuses to format as a memo cell;
instead, it keeps formating as a text cell cutting ...

Weird problem linking to SQL tables - if I create a project and connect to
the DB I can access tables fine - if I create Access DB & link to tables with
ODBC connection when I try to link to tables I get an error 3125 stating that
the primary key fields are not following standard ...

I am currently trying to export data from one of my forms to excel. I
know you can export to excel using macros and vb but i have noticed
that access gives the option to exprot to excel using a template.
How would i create a excel template?

When I format the columns in a query and the export the results to excel I
lose the formatting. How do prevent this?

I'm trying to import data from an Excel spreadsheet. Some of the columns are
dates and times. The cells are formatted as such but when I go through the
import wizard these values are numbers with decimals (in the case of times)
The wizard recognises the field as Date/Time field ...

Is there a easy straight forward way to connect an Access database to a Web
Service?  For example I have a Web Service that returns a typed dataset, how
can I connect this directly to Access?

I'm importing 450,000 records from a .csv file, and the import stops at
record 44,000 and says the record is unparseable in the import error table.
I'm looking at the record, and I really can't tell what's different about it
to make it unparseable.  So what exactly is an ...