Re: Creating forms in Excel to Import access data ! Please reply

Hi,

Easy way: Open MS Query directly - usually in your C:\Program
Files\Microsoft Office\Office or Office11 Folder, file name MSQRY32.EXE.

File>Table Definition, select your database, and set your query - you can
also type in SQL directly. You can then go File>Save As... and save as a
*.dqy or *.qry file. Store these somewhere you can find them.

Back in Excel, Data>Import External Data>Import Data, and navigate to the
query. This should then prompt you for any parameters set up (these work
differently for different database, but a "?" in the SQL will generate the
prompt - even if you ahven't used SQL, go into the code, and replace any
parameters you want to be "live" with a "?")

This should now work ok - I'll monitor this thread, but don't expect
immediate replies ;)

Hope this helps

Sunil Jayakumar







"jwr" <joyrose@xxxxxxxxxxxxx> wrote in message
news:hOt6e.43031$UW6.38153@xxxxxxxxxxxxxxxxxxxxxxxxx
> That is exactly what I want to do -- I don't know how!
> Can you assist or direct me to a website for information?
>
> Thank you,
> jwr
> "Sunil Jayakumar" <sunil.jayakumar[at]gmail.com> wrote in message
> news:ekEi9vmPFHA.3076@xxxxxxxxxxxxxxxxxxxxxxx
>> Hi,
>>
>> I think the best way wold be to actually build the template in Excel, and
>> access a query in the Access database.
>>
>> You can pass parameters back into access when running the query, and
>> emailing out he *** will simply "break" the link to Access, so people
> will
>> be able to view/edit numbers.
>>
>> Hope this helps
>>
>> Sunil Jayakumar
>>
>> "jwr" <joyrose@xxxxxxxxxxxxx> wrote in message
>> news:Vqj6e.49826$f%4.44745@xxxxxxxxxxxxxxxxxxxxxxxxx
>> >I have posted this previously in excel.links without an answer. I am at
> a
>> > standstill now. Your assistance is appreciated.
>> >
>> >
>> > I have an access database. In this database, I have several forms and
>> > reports that need to be sent via email to other individuals. They need
> to
>> > enter info into several locations and then return via email to me.
>> >
>> > If I export the form/report to excel, the format is lost. Is it
> possible
>> > to
>> > create a form/report in excel, import the info from my access database,
>> > and
>> > then email to another location without losing the info and also
>> > allowing
>> > that individual to enter info into specific cells?
>> >
>> > Thanking you in advance.
>> >
>> >
>>
>> www.ayyoo.com/credit-cards.html
>>
>>
>
>
www.ayyoo.com/credit-cards.html


.

Loading