Export / import data (1 Viewer)

le888

Registered User.
Local time
Today, 06:12
Joined
Dec 10, 2003
Messages
344
Hi,

How can I export or import data from my database to Excel? I have securise my database by uncheck all features on the start menu bar. Then, with this I cann't access any more to my tables, if I want to import data from Excel to my database, how can I do this?

Thanks
 

SQL_Hell

SQL Server DBA
Local time
Today, 09:12
Joined
Dec 4, 2003
Messages
1,360
le888 said:
Hi,

How can I export or import data from my database to Excel? I have securise my database by uncheck all features on the start menu bar. Then, with this I cann't access any more to my tables, if I want to import data from Excel to my database, how can I do this?

Thanks

You can do it easily through a report, have a look into this
 

le888

Registered User.
Local time
Today, 06:12
Joined
Dec 10, 2003
Messages
344
SQL_Hell said:
You can do it easily through a report, have a look into this

Thanks,

Look where ?

Le
 

SQL_Hell

SQL Server DBA
Local time
Today, 09:12
Joined
Dec 4, 2003
Messages
1,360
Give It A Try!

Its Not Hard, But If You Do Run Into Problems Then Re-post.

You Could Also Try Looking In The Help File.
 

le888

Registered User.
Local time
Today, 06:12
Joined
Dec 10, 2003
Messages
344
SQL_Hell said:
Give It A Try!

Its Not Hard, But If You Do Run Into Problems Then Re-post.

You Could Also Try Looking In The Help File.

Hi,

I have try to create a command button in the form that send all data to a file but it seem don't work. Can you give an example?

Thanks,

Le
 

SQL_Hell

SQL Server DBA
Local time
Today, 09:12
Joined
Dec 4, 2003
Messages
1,360
Hi,

Sorry I have been off sick for a few days, did you get it working?
 

le888

Registered User.
Local time
Today, 06:12
Joined
Dec 10, 2003
Messages
344
SQL_Hell said:
Hi,

Sorry I have been off sick for a few days, did you get it working?

Yet, it works but in Excel file, the cells are in gray background and the words are in white. How can I change this format ( in Excel or in Access) ?
Another question, I want is to importe data from Excel, I have try to create a same command button but I didn't see where I can find. I have look around in this forum but I didn't found what I want either. Any ideas?

Thanks very much, it was a great help from you.

Le
 

Users who are viewing this thread

Top Bottom