Import Data using Forms

C

carolini

Hi,

Can anyone tell me how I can set up a form to import an excel sheet into an
exisiting table in access?

Thank you!!
 
P

Pat Hartman \(MVP\)

You can use the TransferSpreadsheet Method to import a spreadsheet. The
click event of the button would run the code you write for the import.
 
J

John W. Vinson

Hi,

Can anyone tell me how I can set up a form to import an excel sheet into an
exisiting table in access?

Thank you!!
Click to expand...

You wouldn't use a Form for this purpose, typically; instead you could do it
manually using File... Get External Data... Import, selecting Excel as the
"files of type" argument. Or you could automate the process in VBA code using
the "TransferSpreadsheet" method - see the online help.

John W. Vinson [MVP]
 
S

Susie DBA [MSFT]

you shouldn't be using Access for ETL

learn a real program.. like DTS or SSIS for example

sorry.. but MDB is crap
anyone that uses it is a CON ARTIST
 
T

Tony Toews [MVP]

S u s i e D B A said:
you shouldn't be using Access for ETL

learn a real program.. like DTS or SSIS for example

sorry.. but MDB is cr*p
anyone that uses it is a CON ARTIST
Click to expand...

Note that this person is really A a r o n K e m p f and that he is not an employee
of Microsoft.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
S

Susie DBA [MSFT]

note that Tony is a MDB _WUSS_ and should not be trusted for impartial
advice

Access Data Projects are the rightful heir to the MIcrosoft Access
name.

MDB is for friggin retards
 
Top