I have a number field in a table that I want to export with leading 0's.  For
a number like 100.00, I want to export 0010000.  I multiplied the value by
100 to get rid of the decimal and changed the field format property in the
table to 0000000.  The data looks fine in the table ...

I have several Excel spreadsheets.  One column is numeric.  I have set it to
numeric through the "Format Cells...".  When I try to import it, either from
the excel workbook or a tab delimited file, the numeric values are eith:
1. arbitrarily excluded (some get in, others don't)

I have a db (a) that has about 50 linked tables.  About 20 of the tables I
would like to create make tables of these 20 into another db(b).  
Is there a way to do this without creating 20 make-table quiries and then
running them through 1 macro.

How do I import Adobe PDF data to be used as Access fields?
Thank You!

I have tried to import a DBF database into Access(2000) several times in the
past and was successful. Couple of days ago I tried to do the same with the
same database and got the above error. What can I do to fix this problem?
Please help!

I'm using MS Access 2003 and I am looking for a function that will
search the
entire Tables Collection for a specific string or whole field number
(not part of a field).For example if I enter "widget" or "123456" it

I am importing csv files which may have data errors. I was hoping to use the
error table to identify any errors due to validation rule violations, missing
data etc.
However, when the import is complete the records in error have been omited

My Access application imports a fairly large amount of its information from
Microsoft Excel.  Two tables in my database will need to be updated with
large amounts of data from Excel, and data already in the tables cannot be
harmed.  One of these tables may be updated fairly ...

have new laptop - install window xp pro with 2003 windows office pro , have
odbc data sources created , access database copied from old laptop.  existing
links to sql tables via odbc drivers work fine, i can use and refresh without
problems but when i try to add a new link i ...

I have a problem with the set filter function in foxpro. I want to make
a query that picks out all entries in an field that contain data.. any
data, but not entries that are empty. Is this at all possible?

We have developed an access application with a backend access DB on the
network. The application contains forms that display a lot of data. The
problem occurs when the network connection is lost (e.g. when a client goes
into standy). The forms/queries quite naturally cannot ...

Hello, I work with a system that prints out receipts on a dedicated little
printer whenever there is a transaction.
I want to be able to capture the information onto a laptop that I plug in
instead of the printer, and end up with it all in Access.

Here's my dilemma:
I have a query that I need to ouput to a text file.  I've gotten that much
to work using the transfertext action in a macro. Now, I would like for the
transfertext action to pick up a piece of data from the form to use in the

Hey All,
I currently have a routine that creates a table with a hyperlink reference
to a network location (ACC2003).  This hyperlink ends up being lengthy once
I export this table to HTML.  Is there a way in the export routine to give

I have an excel spreadsheet that I want to import into an access table. I go
to Get External Data and choose the file and go through the dialog boxes,
when I click Finish, I get the following error message: "An error occurred
while trying to import file ….  The file was not ...