Importing Xcel spreadsheet...

[eves]

How do i import excel spreadsheet into the ms access database? i want to get the column names and values in the spreadsheet to be displayed in a dbgrid after i import it...
How can i do that..?

and

is it possible to import tab/comma-delimited file to a dbgrid? if so how do i do that too..?
=)

Thanks..

 

[mymou]

Hi

Have you checked out FILE|GET EXTERNAL DATA|IMPORT?

Stew

"Even a stopped clock tells the right time twice a day."

 

[eves]

Hehehe...i forgot to mention that i wanna import into the dbgrid.. in my vb application...=)

=)