I am importing data from Access into an Excel file. When I do this I can not
get my lookups to work in excel from this data. How do I get Excel to
recognize the data I pull in from Access? I have Vlookups that are not
working plus when it pulls in the date the week formula will ...

I hope that someone can help?
i have a report that generates a billing run for multiple customers and i
want to save each invoice in the report to a location with the filename being
the customer account number and invoice number.

I am reading in a log file which contains file conversion stats for another
program but I am having a problem storing dates and times. The second and
third field in the file is the date and time that the file was converted.  
The date is in the format day of the year and the time ...

I seem to recall that there is a way to have Access automatically convert
numeric data to text when importing into an Access table from an excel file.  
Can a macro be written for this?  Any help or suggestions would be
appreciated.

I am doing some work for a non-profit (marketing work). They have NO central
database and relying on a tool called Survey Monkey which integrates into
their website and allows them to have members fill out information when they
want to sign up for specific roles (helpline, ...

What does this mean exactly?
I have a spreadsheet linked into access. Then I take one column from the
linked spreadsheet and then make an append query. The data type is the same.
Number from the excel sheet and then appended to a number field into a table.

I am trying to use ODBC to connect ot my ERP application. The ERP uses a
Progress database & I am trying to schedule a table update in my Access
application overnight. I can get the schedule to run like I want it to, but
every time I try to connect to the Progress DB I get a ...

I have a requirement to transfer data using a spreadsheet into MS Access
database. This also needs to throw a message saying" X no of records
successfully inserted" in case of successful load, like wise it should pop up
message saying  

Hi Friends,
I saw some of your posts - and I am hoping you can help me with
something i am trying to develop with Excel using Word as the data
source via Access.

I have a table with several fields.  In the design view I have populated many
of the descriptions for each field.  Is there a way to export this
information?
Thanks for the help.

How do I import a text file using a schema.ini file (either working directly
in Access or in VBA).
The help files say you can use a saved specification file or a schema.ini
file, but it doesn't specifically tell you how to use a schema.ini file or

Hi all. I have the following problem. I have created a report that
imports the required pictures stored on the server by using their path
stored in a field in the database. The problem is that a single report
contains from up to 200 pictures and it takes quite a lot of time to

A charitable organization that I am involved with wishes to switch to
Giftworks (with which I am completely unfamiliar) to keep track of donations
and to generate "thank you" letters. So far, their data base, going back
several years, has been on MS Access and consists of (a) a ...

Im trying to take a large excel file and basically have it do this.
It is setup as follows.

I just bought Access 2003 and I'm trying to import data from a FoxPro file.  
I've tried a couple different ways and all I get is a link to the FoxPro file
even though I'm asking for an import.
I need to modify the database structure and add some fields, all of which