In Access say you want create a brand new database and say you want to import
an excel file.
When you go File->Get External Data ->Import do you have Excel as an option
in "Files of Type"?

Hello, I really need some help.  I have an Access 2003 form and a SQL 2000
table.  I have a stored procedure to insert records.  I keep getting a
"Precision is invalid" when I try to execute the stored procedure because I
changed some of my fields to "Numeric" from "Integer" ...

Sometimes this stuff just gets annoying. I have my data displaying perfectly
in my query yet when I export it to a .txt file I am getting this error.
-----------------------------------
Run-time error '3163'

I am trying to load excel files into access but the data contains control
characters like line feeds. When loaded to Access they send the data
formatting out. Is there a way to strip out control characters from a data
file (whilt leaving other characters, numeric, alpha and ...

When reading a split Access DB via an OLEDB connection, does it make any
difference whether I read from the front-end or the back-end database. I
really need to read from the front-end as I have to read queries which are in
the front-end. But is it better to read from the ...

I'm using TransferSpreadsheet to run several queries to a single spreasheet
so that each query has it's own tab in the spreadsheet.  Sometimes, some of
the queries are empty.  Is it possible to specify that if the query is empty,
do not export?

Need help being able to create an import spec for data we receive through
from one of our resources. The data is sent as a text file in the following
format:
Field name00 : value

I made an Export Specification called "PO Export" to export my query with no
quotes (as the other program requires it for import).
I am under the understanding that I can now call this export specification
using Docmd.TransferText but so far I cannot get it to work.

Am trying to export query to a CSV file with header details to a specific
location.
Nearly have it working in that the file is created and stored where I expect
it to be, except tthe file headers are not created even though I appear to

I found this code in a KB article to connect an ADO recordset to a form - it
seems to work fine.  But some of the SQL Server queries are more complex than
others, and I am getting occasional timeout errors.  It would *seem* to be  a
simple fix, but I don't see any change in the ...

I have a file that contains a colum that has data in it that has multiple
delimitations.  (Item#, Quantiity) then each of those are delimitated by a
semicolon
I would like to parse out the items, and quantity to gather the amount of

My company currently has a large amount of data in Excel.  We think we would
be better suited to have it in Access.  However, we need to be able to import
new data on a monthly basis, while simultaneously maintaining the old data in
a monthly and YTD format.  From time to time, ...

My company currently has a large amount of data in Excel.  We think we would
be better suited to have it in Access.  However, we need to be able to import
new data on a monthly basis, while simultaneously maintaining the old data in
a monthly and YTD format.  From time to time, ...

I have Access2003.  I'm creating queries in Excel that run against an ODBC
connection to Oracle.  This works fine, but the error messages are so
primative that I thought I'd try to use Access to run them instead.  When I
try to do this I get a message stating that I have to be ...

I have several querries in Access (for example, "Name and Account", "Name and
Address", "Name and Degree"...) and all those querries' data is from a table
named "Students".
Before with 2005 Access and Excel, I can export each query into the same