By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,640 Members | 2,355 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,640 IT Pros & Developers. It's quick & easy.

Excel to DB format

P: 1
How to collate the data in excel sheet into DB format
Oct 18 '06 #1
Share this Question
Share on Google+
1 Reply


P: 2
How to collate the data in excel sheet into DB format
Hi,

You can first store your excel sheet in txt format by "save as" option and select text tab delimited.

Create a table in the access using "Create table by entering data". Here a table with blank fields is shown.

Click on open and select files of type Text Files "txt".

Then a link wizard will appear that will guide you through the process. Just click next next and the excel data is saved in the table that is being created.

Hope this might help you.

Thanks and Regards,
Gauri.
Oct 19 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.