Skip to Content

Register Login

Industry Online Support

Technical Forum

Navigation

Import and export DB to Excel

Created by: manko at: 11/16/2011 7:56 AM (3 Replies)

Rating (2)

Thanks 3

4 Entries

11/16/2011 7:56 AM	Rate (0)
manko Experienced Member Joined: 9/8/2010 Last visit: 7/9/2019 Posts: 30 Rating: (0)	Dear sir, can we import and export DB to excel?if yes how can one do so?Please help as it will make things easier and will minimise development time.

Suggestion To thank Quote Answer

11/16/2011 8:10 AM	Rate (1)
Ayman Elotaify Platinum Expert Joined: 5/28/2008 Last visit: 10/21/2019 Posts: 4152 Rating: (773)	manko Dear sir, can we import and export DB to excel?if yes how can one do so?Please help as it will make things easier and will minimise development time. Hello, Yes you can. To export DB data to Excel, you can simply copy(Ctrl+C)and paste (Ctrl+V) these data from DB to Excel sheet. To import data from Excel to DB, you have to follow the following FAQ instructions: How do you import an Excel list with STEP 7 variables into a data block? Hope this helps.
	Ayman Elotaify MISC Egypt www.miscegypt.com
Suggestion To thank Quote Answer
This contribution was helpful to 2 thankful Users C-3PO saami

10/8/2012 11:20 AM	Rate (1)
DK80 Member Joined: 9/13/2012 Last visit: 10/8/2012 Posts: 5 Rating: (1)	Automatic generation of an S7 data block (DB) from an MS Excel table I think this has a good chance also.
	Last edited by: DK80 at: 10/8/2012 1:21 PM Last edited by: DK80 at: 10/8/2012 1:20 PM Last edited by: DK80 at: 10/8/2012 11:21 AM
Suggestion To thank Quote Answer
This contribution was helpful to 1 thankful Users C-3PO

10/9/2012 1:13 PM	Rate (0)
EDL AUTOMATION Experienced Member Joined: 10/25/2011 Last visit: 5/1/2015 Posts: 51 Rating: (24)	Thanks DK80

Suggestion To thank Quote Answer

| |

Follow us on