English Boards > Support

seat numbering on one order , clock in/out for waitress,export customers list

<< < (2/2)

lemmings:
Startup Excel, Select Data Tab, Then Get External Data > From Other Sources > SQL Server

Once the dialog box opens up complete the name of the SQL Server and password

Next box asks which database you want to connect to - so this will be SambaData2, then with the connect to a specific table box ticked you can select the table you wish to load - Customers is the one you require in this instance.

The Next box allows you to save the connection and enter a description against it, click Finish.

At this point you will be asked what type of spreadsheet you require and at what position you need the data, you can leave the defaults which will format a table and position the data at A1.

You can save the spreadsheet at this point with whatever name you require.

You also have the option to Unlink the spreadsheet from the Data Connection - but your data will no longer be updated.

NRIKE:
 :D thanks a lot boss  ;D

Navigation

[0] Message Index

[*] Previous page