| Author |
 Topic  |
|
|
camarogal00
Starting Member
USA
3 Posts |
 Posted - 07/14/2012 : 09:39:24
|
| After I imported all fields of my excel file successfully, I cannot find the file in SQL Server 2008 r2. Anyone have any suggestions? |
Edited by - camarogal00 on 07/14/2012 09:40:45
|
|
|
sunitabeck
Flowing Fount of Yak Knowledge
5152 Posts |
Posted - 07/14/2012 : 10:22:55
|
You would not find the file in SQL Server, the data you imported would be in a table. If you used Import/Export wizard to import, it would have asked you for a table name. If you know the name of the table, you can see the data in the table using:SELECT * FROM TableNameHere; If you don't know the name, in SQL Server Management Studio, in object explorer, expand the Tables node under the database name and look for it. |
 |
|
|
camarogal00
Starting Member
USA
3 Posts |
Posted - 07/14/2012 : 23:10:16
|
| I should have explained further. I ran a query to show all fields of data in the table and it was empty except for the headings I had previously created. Am I supposed to do something else after the upload? |
|
|
|
sunitabeck
Flowing Fount of Yak Knowledge
5152 Posts |
Posted - 07/15/2012 : 12:51:58
|
| You should not have to do anything other than importing the data from the file into a database table. Can you describe how you imported it? For an excel file, probably the simplest approach is to use the Import/Export Wizard: http://msdn.microsoft.com/en-us/library/ms141209.aspx |
|
|
|
camarogal00
Starting Member
USA
3 Posts |
Posted - 07/15/2012 : 17:10:32
|
| I use the import/export wizard from the start menu and from the database itself. Both say that it successfully transferred 1743 rows, but when I run the select * from database nothing comes up but the headings. |
|
|
|
sunitabeck
Flowing Fount of Yak Knowledge
5152 Posts |
Posted - 07/15/2012 : 17:45:53
|
When the wizard completes the import, it shows a report including the number of rows imported. Look carefully at the report to see what it says and whether you can get any clues from that.
Other than that, and other obvious (or perhaps not so obvious) things such as making sure that you are looking at the right database, the right schema, the right table name etc., I can't think of a reason why Import/Export wizard would report success, but the data would not be in the table. |
|
|
| |
Topic |
|
Cannot find Excel file after import
