Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can't import from .xlsx
Message
De
06/11/2014 11:46:42
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Import/Export
Versions des environnements
SQL Server:
SQL Server 2012
Application:
Web
Divers
Thread ID:
01610583
Message ID:
01610588
Vues:
26
Thank you Naomi, for your response. You have helped me several times before, and it is always appreciated! I was actually able to obtain Office 2010 and installed it just a minute ago. it solved the problem.

Thanks again.

>>Wow, OK, I am trying to do what should be a very simple import of data from an .xlsx file into SQL 2012. I have tried it using the SQL import wizard by:
>>
>>creating a new table
>>creating a table then trying to append to it
>>saving the .xlsx file as a .xls file, then as a csv file then as a tab delimited .txt file
>>in each case the import it failing.
>>
>>I have installed Office 2007 (the only version I have at the moment) so that SQL has the import tools it seems to need (not sure why they did not put those IN SQL)
>>
>>I can create an Access DB and import the sheet into Access just fine. I tried creating an Access Project, tying it to the DB in SQL, and doing an import into SQL through the Access project, but that also failed.
>>
>>Is Access 2007 not sufficient to support imports into SQL Server? If so, since I dont have Office 2010 or later, what can I do so that I can import this file??
>>
>>SOOOO frustrated at this. Any and all help with this will be greatly appreciated.
>
>What is your SQL Server exact version (are you up to date with Service Packs) and what errors you're getting?
>
>I also suggest to try this forum
>
>https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?forum=sqlintegrationservices where you may get your question resolved quicker. If you post there, please add here link for the reference.
Thank You

Rollin Burr

Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform