access... excel

A

antonov

Hello again everybody.
I have this program I am working on and I have a question:
I need to export data from access to excel (a specific sheet in a specific
workbook). The thing is that this excel sheet need to contain all data from
januari 1st til december 31st. This means that I need the data to go to the
next available free row. The other thing is that the data has to go into
specific cells otherwise the calculations (in excel) won't work. Last
problem (most important): I am not very good with access...... :)
thanks again for any help (you have been of great help so far... thanks)
 
A

antonov

in this all I didn't understand much... next question is: is it possible to
transfer the data from access to excel even if the cells are not adjacent to
each other?
 
D

Douglas J. Steele

Not through methods such as TransferSpreadsheet, but you can using
Automation.
 
A

aaron.kempf

tom tom tom

go and play with your spreadsheets; kid

and i noticed your picture is in northwind or something the other day
lol
 
6

'69 Camaro

Please cross my name off of the list of those wondering whether Aaron can
answer the challenge. While I've seen evidence that Aaron thinks he can
fool people by posting someone else's incomplete code snippet written in a
programming language Aaron doesn't understand as proof that he could have
written it himself in VB (the only programming language he thinks he'll ever
need), I've never seen any evidence that Aaron has the programming skills
and critical thinking skills necessary to solve Harlan's challenges.

Gunny
 
A

aaron.kempf

gunny

you're funny you know that?

im absolutely confident that there ins't a math problem in the world
that excel can do that database can't.

i didnt say i knew all of the math in the world. to be honest; i took
5 semesters of math in college-- 2 review and 3 calc-- and it wasn't
half as much math as what i learned in high school

so if you want to quiz me about shit that i learned while i was still
screwing your mother-- you can-- just dont expect tangible answers

anything that you try to do in excel; i can do easier; faster in the
database world.

'ohhh-- but it's soooooo hard to setup tables <gag>'

go play with your spreadsheets little boy
 
A

aaron.kempf

you of course you can import cells that aren't next to each other

a) import the whole xls into a database
b) grab the columns; rows you want
c) push them where you want them with an append query
d) uninstall excel from every machine at your company
e) fire the beancounters who can't do a single goddamn thing without
copying and pasting
 
Top