You are viewing limited content. For full access, please sign in.

Question

Question

Dynamic Fields Using a Spreadsheet

Empower14
Updated January 28, 2014
asked on January 27, 2014 • Show version history

In the Advanced Metadata class at the conference a spreadsheet was used to populate a database for Dynamic Fields. A program was used to take the spreadsheet data and populate it into SQL. Can anyone tell me what program was used to do it?

0 0

Answer

APPROVED ANSWER SELECTED ANSWER
replied on January 28, 2014 • Show version history

Yes, that was my class!  The program is called "Import and Export Data (32 bit)", and I know it's available with Microsoft SQL Server 2008 and 2012 (and quite probably with other versions, too--I just know I've used it with those versions).  I believe it's an optional component of the SQL installation, though, so if you don't have it installed you might need to re-run the installer and be sure to select it.

 

It allows you to populate a SQL table with an Excel spreadsheet, or, if you're using another spreadsheet program, you can use a .csv file instead. (To use it with an Excel spreadsheet, you choose Excel as the file source; to use it with a .csv file, you choose Flat File Source.)

 

Note that there is also an "Import and Export Data (64 bit)" available, but it doesn't appear to be supported with Excel, so even if you're on a 64-bit computer, you should use the 32-bit version of the wizard.

 

We have complete instructions for this process with Excel 2010 and SQL Server 2008 here: http://www.laserfiche.com/support/webhelp/Laserfiche/9.1/en-US/AdminGuide/LFAdmin.htm#Using_MS_Excel_Create_External_Table.htm  (The steps will be largely the same for other versions of Excel and SQL Server. They're essentially identical for a .csv, but--as noted above--you'll choose Flat File Source as the source type.)

2 0

Replies

replied on January 27, 2014

You can use SQL Import Agent to import information from CSV/excel/flatfile source to import data to SQL table. 

0 0
replied on January 28, 2014

Do you know if that's what was used in the class?

0 0
APPROVED ANSWER SELECTED ANSWER
replied on January 28, 2014 • Show version history

Yes, that was my class!  The program is called "Import and Export Data (32 bit)", and I know it's available with Microsoft SQL Server 2008 and 2012 (and quite probably with other versions, too--I just know I've used it with those versions).  I believe it's an optional component of the SQL installation, though, so if you don't have it installed you might need to re-run the installer and be sure to select it.

 

It allows you to populate a SQL table with an Excel spreadsheet, or, if you're using another spreadsheet program, you can use a .csv file instead. (To use it with an Excel spreadsheet, you choose Excel as the file source; to use it with a .csv file, you choose Flat File Source.)

 

Note that there is also an "Import and Export Data (64 bit)" available, but it doesn't appear to be supported with Excel, so even if you're on a 64-bit computer, you should use the 32-bit version of the wizard.

 

We have complete instructions for this process with Excel 2010 and SQL Server 2008 here: http://www.laserfiche.com/support/webhelp/Laserfiche/9.1/en-US/AdminGuide/LFAdmin.htm#Using_MS_Excel_Create_External_Table.htm  (The steps will be largely the same for other versions of Excel and SQL Server. They're essentially identical for a .csv, but--as noted above--you'll choose Flat File Source as the source type.)

2 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...