• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 3. Rapid Rows, Cruising Columns:... > Importing Structured Data: the Prequ...

Importing Structured Data: the Prequel

Stuck in static land and can’t go dynamic? Dreamweaver has a cool command that enables you to bring in data from a spreadsheet or database program—all you need to do is output the data in the proper format. And what’s the proper format, you ask? Dreamweaver’s File > Import > Tabular Data feature is pretty flexible and can work with almost any kind of text file where the data is separated or delimited by a certain character. Typically, you’re trying to bring in data from either a spreadsheet program such as Microsoft Excel or a database program such as Microsoft Access. Just to mess with your head, these two programs use different commands to do the same thing. Here’s a little help to get your data moving on the right track from those programs into Dreamweaver.

From Access, begin by selecting a table or query before choosing File > Export, and then set the Save As Type option to Text. Clear the Save Formatted check box. When you click Save, the Export Text Wizard appears. Although there are many ways to go, the best combo I’ve found is to choose Delimited on the first step and then select Comma as the delimiting character, with Quotes as the Text Qualifier. (If your data has quotation marks in it, choose Tab as a delimiter and None as the Text Qualifier.)


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint