Hey there,
I get the following error when running an export of a table through a macro
that is linked to a button on a form:
The Microsoft Jet database engine could not find the object 'Scripts'.

anybody know how to convert omnis7 data base file into access file or even
into a flat files (text)

Is it possible to import data directly into an Access 2003 template. Example:
Using template #01018584 (Membership) when I go to Tables; Members and use
the "Get External Data" link. It imports the data, however it creates a new
folder.

I link an excel file.
In a row, i have mixed type
some are seen as text, some as number
i.e. in one colum

Hi, I am exporting data from a table to a fixed-width text file using an
export spec.
One field I export is a text datatype, but it does only contain numbers. I
used a text datatype because I need to preserve the leading zeros. The end

I want to import an excel file with transferspreadsheet
Is there a way to specify a range like from the 6th row to the bottom (may
vary from one import to an other)
I was looking for something like

please tell me how to import excel work sheet to word?

I'm trying to create a knowledge base in access and want to create a field
that will accept attachments or open to a specific word document or e-mail.  
Ideally the user would be able to click on the attachment and open the
supporting e-mail etc.

Hi I have a simple database which has a master table for suppliers, with a
sub-datasheet of Supplier Offers, which has a sub-datasheet for Supplier
Items.
To simplify data entry of similar data, I have had a request to setup a

I have a query that I need to export the results to a dbase file format. In
using the Macro function .dbf is not one of the choices and there are two
many records to export to a Excel file.
Does anyone know how I can export to .dbf format other than creating a new

I have a query within Access which extracts information on territories. These
territories are listed from 1 through to 10. What I need is for the raw
information from the access query to be then exported into Excel. But with
all the information regaridng territory 1 to appear ...

I have two or three simple accounting Access files, each for seperate fiscal
year to avoid any difficulty in manipulating large data/file.
the problem is that sometimes when I work in the current year /file, I need
to see previous years' data as well, and I thought that I can do ...

Is there any way to control the data type when importing Excell Spreadsheets?
I import part numbers from several different suppliers.  Some of their p/n's
are text, some are numeric most are mixed.  I wish to link spreadsheets from
a supplier and view the p/n field as text.  I ...

Hi,
I was looking to export data from an Access (2003) Report or Query into an
Excel worksheet or workbook.  In doing this, I want to create a button that
performs this function, instead of clicking on export data or save as.  The

I am trying to import an Excel spreadsheet that has a fixed number of columns,
but unknown number of rows. For some reason importing it brings in all 256
columns despite the fact that I'm only using 10.
I have also seen cases where it brings in tons of blank rows of which I have