Export / import data (1 Viewer)

le888

Registered User
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
Joined
Dec 4, 2003
Messages
1,336
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
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
Joined
Dec 4, 2003
Messages
1,336
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
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
Joined
Dec 4, 2003
Messages
1,336
Hi,

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

le888

Registered User
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 (Users: 0, Guests: 1)

Top Bottom