Is it possibe, and if so what is required, to access SAP
tables from MS Access??

Is there an easy way to split one field into 2?
I have delimited file to import into my db.  It imports
fine with a macro I've set up.  What I'd like to know
though is once the data is in can I take Field1 and split

Can anybody advise where can i find some diagnostic
information as to why an import from an excel spreadsheet
is failing?  Is there an error log?  does it get saved?
Thanks very much

I'm a beginner with Access and have hit the following
problem.
I have an Excel spreadsheet with a number of workbooks.
Each workbook contains a different set of columns; some

I have a few access front ends that link to either an oracle 8 back end or a ms sql 7 back end.  Everything works fine except for 'automatically' linking to the backend, so the user does not have to enter a user / password combo on first use of the front end.
I currently do not ...

I am using TransferText within a macro to output a query
that contains date fields. In the query, I formatted each
field as short date.
TransferText puts out the date and time as 01/29/2004

I am trying to import a dbf table into access.  I have no
problems with files that do not have memo fields, but
when they have a memo field (.dbt) I get the following
message when I attempt the import:

I have a database that was burned on CD so that we could
maintain the database as of a certain day.  I then created
a separate database so that I could run queries off tables
I imported from the first database.  My problem is this:  

I have a database on a network, when I open and print a
report and export it to snapshot viewer it works fine, but
when someone else opens it and tries to export it to
snapshot viewer it goes over minimized and you can not

Hello... yesterday I posted a question regarding linking
access and excel, and I was told I can do it via
SQL.REQUEST. Everything works now, but one thing would
save me lots of grunt work. Is there a way to link excel

Can you create a relationship between a linked oracle
file using an odbc driver and an existing Access table?  
When I do this and try to create a query, then my Access
completely shuts down.  So I am thinking that it is the

I am exporting data from Access 2000 to comma delimited
text file. I am not using an export specification. I have
been doing this successfully for years. All of a sudden
the TransferText action stopped working as it had been.

I thought I had this finished but my client threw me a
curve.  If anyone out there can help - I've tried....
Below is what I need to import
01001,PHOS. LINE 2 2A PUMP,00,P2-2A-1087-C,2,316L

I am having troubles trying to import a comma delimited
text file into an existing database. The database uses a
primarykey set to autonum. When trying to import there is
an error becuase the field i have for the key is blank. I

Hello... I'm trying to set up an excel sheet in such a
manner that if a certain record exists (based upon it's
primary keys) in an Access database, the cell will return
X, and if not, it will return Y. Is there a method to hook